Extract numbers before and after decimal separator
Posted: Thu Mar 12, 2015 11:26 am
on mouseDown
If field 1 as an example contains 197.256221
How do I extract all the numbers before a decimal point and place those into field 2 (in the example would be 197)
and then also extract all the numbers after a decimal point and place those into field 3 (in the example would be 256221)
Thanks
Dave
If field 1 as an example contains 197.256221
How do I extract all the numbers before a decimal point and place those into field 2 (in the example would be 197)
and then also extract all the numbers after a decimal point and place those into field 3 (in the example would be 256221)
Thanks
Dave