| Issue with CSV file. Please help [urgent] [message #324760] |
Tue, 03 June 2008 23:30  |
rak007
Messages: 45
Registered: October 2006
Location: Mumbai / Pune, India |
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  |
anacedent
Messages: 6777
Registered: July 2005
Location: surf meets turf in 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 |
rak007
Messages: 45
Registered: October 2006
Location: Mumbai / Pune, India |
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 |
Michel Cadot
Messages: 18894
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Did you try Microsoft site?
Regards
Michel
|
|
|
]
Members
Search
Help
Register
Login
Home
