Regex for formatting numerical values

Question

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!

jl4357 · Answer

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 :)

caltang · Answer

Err I recall seeing this post a few days ago. I think it was solved by @binu_acs already right?

caitlynmcintyre · Answer

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