| Issue with CSV file. Please help [urgent] [message #324760] |
Tue, 03 June 2008 23:30  |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
