[Solved] Export to CSV - Add ; at the end of each line

[pyo]

Hi guys,

I am preparing a CSV file according to the bank's specs (exporting sheet with a list of transfers).
2 issues here:

1/
I cannot find any way to have ; (semicolon) at the end of every line.
Semicolon is the field delimiter here - and obviously divides every cell - but doesnt show up after the last cell of each line.
Is there any way to fix it? Or add ; in every line in some other way?
(there are too many lines and too many files to make it by hand)

2/
I need to have every cell quoted - I do have "Quote every cell" checked at export panel.
But there are 2 columns that are empty - no string nor value in these cells - and Calc doesnt qoutes them
In the csv file as a result for this cols I need: ;""; but have only: ;;
I cannot have space there.
Is there any way to force Calc to add the quotations marks for empty cell?

[Villeroy]

If your csv has a header row on top, append an additional header which appends another column of empty cells represented by a trailing semicolon in each row.

[Villeroy]

And formula ="" creates an empty string.

Code: Select all

"ID";"PID";"CID";"D";"V";"X"
0;4;4;06.11.2005;303,63;""
1;2;1;07.04.2008;586,93;""
2;6;2;19.05.2007;80,3;""

[MrProgrammer]

I am preparing a CSV file according to the bank's specs (exporting sheet with a list of transfers

First File → Save As → File type → ODF Spreadsheet → ✓ Automatic file name extension → Save (to preserve the original content)
After that, File → Save As → File type → Text CSV → ✓ Automatic file name extension → Save then File → Close

Using Writer, create a new, empty text document then Insert → File → «your saved CSV file» → Open

I cannot find any way to have ; (semicolon) at the end of every line.

Edit → Find & Replace → More options, check Regular Expressions, Search for .+ (period, plus), Replace with &; (ampersand, semicolon), Replace All. I recommend unchecking Regular expressions, before clicking Close.

But there are 2 columns that are empty - no string nor value in these cells - and Calc doesnt qoutes them In the csv file as a result for this cols I need: ;""; but have only: ;;

Edit → Find & Replace → More options, uncheck Regular Expressions, Search for ;; (semicolon, semicolon), Replace with ;""; (semicolon, quote, quote, semicolon), Replace All, Close.

Save the repaired CSV file with Writer, File → Save As → Type type → Text. If you need any additional assistance attach a document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.