Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anonymous Anonymous
  Where is Anonymous Anonymous?
 
 Netherlands
 Anonymous Anonymous
 Tags
Subject: xls to csv
Thread ID: 112350 Message ID: 112350 # Views: 2 # Ratings: 0
Version: Not Applicable Category: 3rd Party Software
Date: Tuesday, November 07, 2006 4:34:15 PM         
   


hi Guys,

I hope you can help me. i have a problem with my .xls file, i want to convert it to .CSV but the problem my columns in xls conatins the ff;


Column A Column B
1 Foxite Eric
2 Foxpro Andy, Marcia
3 Office Eric, Andy, Marcia

Notice Column B has a comma, so when i SAVE AS my .xls to excel into .CSV, the comma is consider a separator to column B, so when i parse Column B is consider a new column :( is there a better way or other 3rd party tool so that it will automatically change first the comma into let say semicolon before converting it into comma delimited textfile.

Like

Column A Column B
1 Foxite Eric
2 Foxpro Andy, Marcia
3 Office Eric; Andy; Marcia

when converted

Foxite,Eric,Foxpro,Andy;Marcia,Office,Eric; Andy; Marcia,


Thanks,

Michael

ENTIRE THREAD

xls to csv Posted by Anonymous @ 11/7/2006 4:34:15 PM
RE: xls to csv Posted by Yuri Rubinov @ 11/7/2006 5:37:55 PM
RE: xls to csv Posted by Anonymous @ 11/7/2006 6:59:24 PM
RE: xls to csv Posted by Yuri Rubinov @ 11/7/2006 7:16:15 PM
RE: xls to csv Posted by Anonymous @ 11/7/2006 9:05:36 PM