Convert from Scientific Notation (E) to String Value

Question

Hello,

I am trying to convert some numbers from the screenshot below to string. I tried to add a letter in front of the number and then trim it, didn't work. Also, I tried to use ToNumber but it takes out the numbers from other rows where I have combinations of digits, letters and sometimes special characters. I cannot put the data type to be fixed decimal because I also have some other instances where it looks something like 1234_abcd_123 (up until 15 digits).

I modified with the help of Select Tool to any type of string (and forced), with no luck.

Thanks in advance!

mst3k · Answer

i assume the field is a text datatype then, if you have these "1234_abcd_123" values?

you should be able to do something like what's attached by parsing out the number and the exponent and then doing simple math functions. you'll have to modify the formula to work for these other strange values you have, to parse out whatever number it's supposed to be

so, what's interesting here is that the "final_number" wound up being -9852160 despite the original being -9852060. there may be floating point number issues coming into play in this kind of setup?

ScientificNotation.yxmd