String to Numeric
Hi all
I have a file that's got a column of numbers stored as strings. Where a number is negative, rather than it showing in the usual way, it's shown with an "R" (for refund) after the numerals - so 6.80R for example. I've been trying to create a calculated field that'll manipulate those strings so that I can then convert the whole column to numbers, including negatives, rather than characters but I'm not getting anywhere. Does anyone have any suggestions please?
Thanks
Andy
------------------------------
Andy Coles
Pension Manager
Dorset Healthcare University NHS Foundation Trust
01305 361302
------------------------------
I have a file that's got a column of numbers stored as strings. Where a number is negative, rather than it showing in the usual way, it's shown with an "R" (for refund) after the numerals - so 6.80R for example. I've been trying to create a calculated field that'll manipulate those strings so that I can then convert the whole column to numbers, including negatives, rather than characters but I'm not getting anywhere. Does anyone have any suggestions please?
Thanks
Andy
------------------------------
Andy Coles
Pension Manager
Dorset Healthcare University NHS Foundation Trust
01305 361302
------------------------------