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.
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)
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)
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)
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)
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)