xls2csv can't handle dates.

zebela · 02-09-2009, 09:49 AM

I need to convert excel (.xls) files to ascii files with coma sep.

Code:

xls2csv -f%d%m%y <my_file>

gives date with 4 years and a day more than in the .xls files.

25/07/2008 turns 26/07/2012

Please help

Alain.

TB0ne · 02-09-2009, 11:06 AM

Quote:

Originally Posted by zebela

I need to convert excel (.xls) files to ascii files with coma sep.

Code:

xls2csv -f%d%m%y <my_file>

gives date with 4 years and a day more than in the .xls files.

25/07/2008 turns 26/07/2012

Please help

Alain.

Please don't post the same question in multiple forums.