LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: moko

Hi,

I am looking to convert an attribute from Double back into a String format but the approaches that I have tried so far have been unsuccessful. Below you will see an example of the data used, with RMS_NOTIONAL_TEST being the converted attribute:





Ideally I am looking for a solution where RMS_NOTIONAL_TEST will output the exact same results format as RMS_NOTIONAL but also converted to a String. I have been looking into using format() but with no joy as yet.

Do any of you have any suggestions?

Thanks in advance!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Hi Michael,

To get more control over how numbers are formatted, look up the format() function in help. Below I used the %f format to always write the number without ever using the exponential notation.

f = if 'RMS_NOTIONAL'.isNull()
then str(null)
else format("%f",'RMS_NOTIONAL')
emit f as "format_f"

See the attachment for additional options.
Attachments:
x.brn

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: moko

Perfect! Thanks for the quick response

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rbeliz000

I would like to convert several columns in a file from string format, basically the inverse of this original post . What is the best method for doing accomplishing this? Any guidance would be much appreciated.

thanks.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

The answer to that might be trivial, lets see if it works for you. Use the double() function.
d = double("123456.789")

or
s = "12345.678"
d = double(s)