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
 To: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 Tags
Subject: RE: xls to csv
Thread ID: 112350 Message ID: 112366 # Views: 2 # Ratings: 0
Version: Not Applicable Category: 3rd Party Software
Date: Tuesday, November 07, 2006 6:59:24 PM         
   


Hi sir,

thanks for the reply, yeah actually i got it, when excel converts into .csv it provides a double qoute where column has a comma. Coz what happen, i get data via comma, meaning the pattern that separate the fields/column is the comma, now the trouble i have is that i didnt know that it was double qouted automatically :).

Anyways thanks for the repsonse,

mike

> > 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

>
> Hi Michael,
>
> Not quite clear how do you get into this problem. Here is what I am getting when I open the xls file in Excel, and use SAVEAS /type CSV (comma delimited)(*.csv)/ option in Excel:
>
>
> 1,Foxite Eric
> 2,"Foxpro Andy, Marcia"
> 3,"Office Eric, Andy, Marcia"
>
>
>
> Could you provide any other details?
>
>
> Yuri Rubinov


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