Hi, I have a CSV file that has its fields separated by a semicolon. When I save the CSV file from LibreOffice Calc, I do not seem to have the option to change the separator (to comma). Does anyone know how I do this?
Thanks.
Found it! You need to click on “Edit filter settings” when you save the file, this gives you the option to save various file settings when you save.
Yes! This works for me.
You can save with a semicolon as delimiter.
Steps:
- Save As
- Scroll down the format roll down menu towards almost the end
- Select: Text CSV
- Click SAVE
=> New window: Confirm file format - Select: Use Text CSV Format
=> there you can make all needed settings including setting the delimiter to semicolon. - Click OK once all parameters are set.