Formatting Values in CSV

Question

Hi all,

I've got a range of CSVs that are ~200 columns, with multiple discrepencies in the formatting in them (i.e., some have £ symbols...others use GBP, some use k, others use exact figures, others use ',000').

Was hoping someone could point me in the direction of a tool/process that'll amend these en masse. I've tried using RegEX and Find Replace, but these both seem to be aimed for specific columns, whereas I'm looking across a much wider dataset, and don't fancy copy & paste that many times.

Thanks for any help,

Dan

danilang · Accepted Answer

Hi Dan(you can never have too many)

Check out the Multi-field Formula tool.  It allows you to a apply a formula to multiple fields at the same time.  Select the type of fields, string, numeric, etc and then the individual ones.  The expression then applies to all the selected fields

Dan