Not sure if this is a bug or not. It seems like one, but I will let you decide that. I am trying to convert a number in scientific notation (for example, 1.67407E-05) to a decimal. I am using string substitution to remove the “E-05” from the end - this works. Then I am using simple maths to divide the number by 100000 - this seems to work too. I get, in the log (variable is fxMultiplier):
1.67407 / 100000 = 0.0000167407
Then I try to set a string variable (fxMutiplierString) equal to the number that was the result of the simple maths, and both the original variable and the new string variable are set back to scientific notation!
Current variable values :
fxMultiplier = 1.67407E-5
fxMultiplierString = 1.67407E-5
Setting the string variable is not the issue…if I just keep the numeric variable, it does the same thing. How do I escape scientific notation and export the number as a decimal?
EDIT: I figured out how to use formatting to format as a fixed decimal instead of using scientific notation. However, I cannot now figure out how to remove the padded whitespace from the left side of the values.
SECOND EDIT: While I could not remove the padded whitespace, it was not necessary when uploading the data. So I am basically good…I guess now I am just wondering why the DEFAULT is scientific notation, and whether that itself can be changed.