Hi there,
I am struggling to build a regular expression to help with a scenario.
I have a column, string type, that has various kinds of data. I am looking to format the numeric values in this column like so: 12345.6789 to $12,345.68. I included a screenshot of sample data, before and after, below.
Does anyone know how to achieve this formatting?
Thank you for your help!
Hello!
You can use the formula tool with this
IF Contains([Before], '%') THEN [Before]
ELSEIF REGEX_Match([Before], '\d+\.?\d*') THEN '$'+ToString(ToNumber([Before]),2)
ELSE [Before]
ENDIF
Err I recall seeing this post a few days ago. I think it was solved by @binuacs already right?
Correct, this was already solved - sorry for the confusion! My original post did not go through, but seems to have now posted several days later :)