I get the file as CSV in the email and everything is fine except the following missing rows problem:
PROBLEM: Some fields in the CSV have a quotemarks ( " ) because of which some records are missing in the CSV in the email, though these rows are present on the csv file on the unix box.
Also, if the csv email attachment is opened in a notepad, those rows can be seen.
Is there a way of getting those missing rows in the excel, please?
Notice that the last column of the 1st and the last row have a single quote mark. I think because of which all the rows between these two rows are missing in the email attachment when it is opened as an excel sheet. however, they are seen if opened in a notepad.
aaa,aaa,aaaaaa,aaaaaaaaa,aaaaaaaaaaa,"aaaaaaaaaaa (in CSV)
is seen as the following in notepad
aaa,aaa,aaaaaa,aaaaaaaaa,aaaaaaaaaaa,\"aaaaaaaaaaa (in CSV)
And in the excel sheet also it looks like the following:
aaa,aaa,aaaaaa,aaaaaaaaa,aaaaaaaaaaa,\"aaaaaaaaaaa (in excel)
But I want the following in excel sheet:
aaa,aaa,aaaaaa,aaaaaaaaa,aaaaaaaaaaa,"aaaaaaaaaaa (in excel)
The problem is that it seems a property of excel to put everything between 2 double quotes in one field or if a field value bigins with a single double quote, it automatically ends that field with a double quote as well or puts all rows after it into one field.
I think I might have found the solution though. If so, I will post it shortly. thanks again for your help.
Hello
I have a script which converts log to csv.
Now I need to have xls.
Is there any easy way/command which can convert csv to xls?:confused:
preferably just using bash and not perl,... is it possible? (1 Reply)
I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet
Thanks so much
JAvier (3 Replies)
Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading.
All the trading run's in Redhat or Solaris environments.
We run a script on a Redhat server whitch generates the stats in CSV format.
After we download we open it in Excel and... (3 Replies)
Hi does anybody know how to convert xls to csv undex linux.
I need only data (that is log from test, dont need any macro and so on) from xls.
Any idea how to do that? Perl? shell? Could you give me any example?
Thanks in advance for answer.
Gracjan (4 Replies)
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)