I have a text file (long string field) and I need to extract a price (sometimes with thousands separator, sometimes with decimal places, sometimes as whole number).
I need to extract the right column of the left one. Any ideas how to code the pattern? The thingies in red are the desired outcomes.
REGEXP_EXTRACT([Long field string],'((?<=")[\d$,.]+|\d+$)')
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...