MoneyWorks

Result Type: Text

Definition: Manually parsing CSV is tricky, because it may contain quoted fields that themselves contain commas and possibly even quoted quotes. This function converts such CSV to easily sliceable tab-delimited text. By default the field separator is assumed to be a comma (the C in CSV), but in some locales it is also common to use a semicolon to separate fields in case comma is used as a decimal separator. You can optionally pass a single ASCII character as the second parameter and that will be used as the separator.

Examples:  ParseCSV(`1, 2.50, "three, four", 5\n`)

Availability:  v9.1.6 and later.