Home » Other » General » Issue with CSV file. Please help [urgent]
Issue with CSV file. Please help [urgent] [message #324760] Tue, 03 June 2008 23:30 Go to next message
rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
Hi all,
I am having a few issues with a CSV file i am trying to create. The steps that i am following are.

1. Open excel and create some data in sheet1
2. I insert 7 columns and some 30 rows but only for col1 and col2. Rest all columns(col3 to col7) remain blank
3. I save the xls and then again do a save as to .csv format
4. After saving in csv if i open the file in a text editor like notepad only the first 16 lines have the 6 commas (,) and the remaining rows dont have and commas after the first two row data.

I am attaching the files here.
Please view the files in this order for a better understanding:

1. Book1.xls
2. Book1.csv
3. Book1.txt

Please let me know how can i get the commas in each of the rows. I need data in this format to be processed.

PS: Please rename the file extension as zip and extract the contents.
Re: Issue with CSV file. Please help [urgent] [message #324763 is a reply to message #324760] Tue, 03 June 2008 23:36 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above.

>Please help [urgent]
Please explain why it is urgent for me to solve this problem for you.

Did you happen to notice that this forum is dedicated to ORACLE issues?

Please go post this in any Excel forum of your choosing.
Re: Issue with CSV file. Please help [urgent] [message #324775 is a reply to message #324763] Wed, 04 June 2008 00:05 Go to previous messageGo to next message
rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
It wold be really great if you could suggest me one. I am not aware of any.

Thanks
Re: Issue with CSV file. Please help [urgent] [message #324776 is a reply to message #324775] Wed, 04 June 2008 00:06 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try Microsoft site?

Regards
Michel
Previous Topic: Oracle Critical Patch Update Synchronization
Next Topic: Sybase DBA issues!!
Goto Forum:
  


Current Time: Tue Dec 06 14:23:34 CST 2016

Total time taken to generate the page: 2.96887 seconds