I'm currently using the default Numbers application to open my CSVs. My current use case involves a file that I had to use a different type of separator (
|). Is there any way to change the separator? Right now when I open the file it just puts the entire row in one column.
sed; the Stream EDitor from Terminal.
sed -i -e 's/"|"/|,"/g' filename
s is used to replace the found expression "|" with ","
g is for "global", meaning do this to the whole line. If you omit the
g option it will only replace the first instance, ignoring the rest
-i option is to "edit in place" meaning it changes the file itself.
-e option indicates the expression/command to run.
Numbers >=5.0 after opening a csv-File you get a floating dialog "Table data was imported. Adjust Settings". When hitting "Adjust settings" you can control the delimiters. Found this solution in this tutorial