Save as csv creates trailing space

Topic

New Reply

have an excel sheet where saving as file format xlCSV keeps all of the columns but one column is having a trailing space added to the text.

[TABLE=”class: grid, width: 500″]
[TR]
[TD]EMPLOYEE[/TD]
[TD]PAYCODE[/TD]
[TD]HOURS[/TD]
[TD]DATE WORKED[/TD]
[TD]PROJECT[/TD]
[/TR]
[TR]
[TD]NE00001[/TD]
[TD]LSHR[/TD]
[TD]45[/TD]
[TD]01/24/2016[/TD]
[TD]default[/TD]
[/TR]
[TR]
[TD]NE00022[/TD]
[TD]LSHR[/TD]
[TD]36.5[/TD]
[TD]12/12/2015[/TD]
[TD]default[/TD]
[/TR]
[TR]
[TD]NE00058[/TD]
[TD]LSHR[/TD]
[TD]45[/TD]
[TD]01/17/2016[/TD]
[TD]default[/TD]
[/TR]
[/TABLE]

when the file is saved, it adds a trailing space to the PAYCODE entries so ‘LSHR’ becomes ‘LSHR ‘

Anyone come across this previously?
thanks

Reply | Quote

Replies

As a CSV, the fields should be enclosed in quotes, e.g. “LSHR “. Is this what you see?
Do you have a further column in the spreadsheet that contains a space?

cheers, Paul

Reply | Quote

Thanks Paul No there is no column with a space in it..however, I have just managed to solve it.
The problem arises when the formatting of the column is indented and vertical centre.
I set the formatting to left basic cells and the column now saves as csv without the trailing space.

bit of a gotcha problem with the formatting dictating the resulting csv output.

thanks for checking Paul.

Reply | Quote