Hi there,
I have a column (string) with various types of data, including text and numerical values. I am hoping to format the numerical values as follows - 12345.6789 to $12,345.68 - but haven't been able to get a regular expression working. I've included a sample of the values, before and after, below.
Can anyone help with creating an expression that would achieve this?
Thanks for your help!
Solved! Go to Solution.
@jl4357 One way of doing this
Thank you very much for this! I tried it out and it is working.
Do you know of a way to add the thousands delimiter/comma to this formatting as well?
@jl4357 @Update the toString function by adding 1 after the 0.01 argument
eg:
ToString([Field], 2,1)
@binuacs lightning fast response man!
Perfect, thank you for the quick response and very helpful solution!