Setting for semicolon as CSV separator?

#1

I want to generate CSV files that use a semicolon ; rather than a comma , as field separator.

The comma is especially problematic because I can’t just search&replace , for ; because random company names then become e.g. “Gaylord; Lakin and Grady” (yes, that’s an actual sample).

Your help is much appreciated!

#2

@benbrown
Just switch from CSV to Custom. You may need to rename the file to CSV after download as it defaults to .txt
Tab delimited may also suit your purpose but also downloads as .txt

#3

switch from CSV to Custom

D’oh! :slight_smile: Yes of course! Why didn’t I see that? Thank you!