Extracting Text with quotes

I have a csv file with one record on each line and the fields separated by not just commans but quotes too. So the delimiter includes the quotes and is "," instead of just ,

I see that there is a parameter in the StrExtract to customize if not just a comma but I can't get this to work. Can someone suggest what the parameter should be?

There is no single function, but you can use StrReplace to first replace "," sequence with some other delimiter:

input = StrReplace( input, "\",\"", "|" ); // replace "," with single character
input = StrReplace( input, "\"", "" ); // remove remaining double quotes
field = StrExtract( input, field_no, '|' ); // extract any field
1 Like

Thanks you so much for the quick reply.