Forum     

Go Back   Digit Technology Discussion Forum > Portables, Peripherals and Electronics > QnA (read only)
Register FAQ Calendar Mark Forums Read

QnA (read only) Mods please help transfer the contents of this forum to proper sections. :)


 
 
LinkBack Thread Tools Search this Thread Display Modes
Old 04-06-2008, 09:54 AM   #1 (permalink)
Alpha Geek
 
raksrules's Avatar
 
Join Date: Nov 2006
Location: Mumbai <-> Pune
Posts: 527
Unhappy Issue with CSV file. Please help[urgent] !!


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 change the extension of the two files accordingly. Keep the Book1.txt as it is
Attached Files
File Type: txt Book1.xls.txt (14.5 KB, 2 views)
File Type: txt Book1.csv.txt (721 Bytes, 0 views)
File Type: txt Book1.txt (721 Bytes, 2 views)

Last edited by raksrules; 04-06-2008 at 01:18 PM.
raksrules is offline  
Advertisements. Register and be a member of the community to get rid of them.
Advertisement

Old 04-06-2008, 12:01 PM   #2 (permalink)
The real Bond
 
yogeshm.007's Avatar
 
Join Date: Feb 2008
Location: Earth... Not the google one
Posts: 169
Default Re: Issue with CSV file. Please help[urgent] !!

I could not open the zip file; it seems to be corrupted.
yogeshm.007 is offline  
Old 04-06-2008, 05:34 PM   #3 (permalink)
Apprentice
 
Join Date: Dec 2007
Posts: 53
Default Re: Issue with CSV file. Please help[urgent] !!

yeah me too!! I think there is some error in the way u r trying to save the csv format?
__________________
http://curlit.in : URL Shortener
My tech blog : http://www.crankup.net
shobankr is offline  
Old 04-06-2008, 06:47 PM   #4 (permalink)
Alpha Geek
 
raksrules's Avatar
 
Join Date: Nov 2006
Location: Mumbai <-> Pune
Posts: 527
Default Re: Issue with CSV file. Please help[urgent] !!

The same does not happen if i use Excel 2007 to create a save the CSV file.
Currently i am using Excel 2003.
raksrules is offline  
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
urgent vista issue sushantsaurabh Software Q&A 5 03-03-2008 11:36 AM
.doc file problem...please help..uRGENT windchimes Software Q&A 6 17-11-2007 10:40 AM
Urgent Hidden Folder Issue arfakchoudhury Software Q&A 3 20-04-2007 09:04 PM
Media file issue... again... rakesh14021983 QnA (read only) 4 09-02-2007 09:40 PM
Forum Query / Issue ....Urgent :) Wizard No.2 Internet & WWW 2 23-03-2005 02:58 PM

 
Latest Threads
- by gohan89
- by gforz
- by Who
- by clmlbx
- by Tenida
- by clinton

Advertisement




All times are GMT +5.5. The time now is 08:48 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.

Search Engine Optimization by vBSEO 3.3.2