parsing csv

[Azar]

Hi all,
I am converting a text file to a csv file.
after converting, i run a text to columns to place the data in different cells.
somewhere along the way, i seem to loose numbers that are in thousands.
anyone have an idea why this might happen, or how i can avoid it?

thanks,
Az

 

[shg]

Are there commas separating the thousands in the CSV file?

 

[Azar]

yes
thanks

 

[Greg Truby]

Is the number of fields otherwise constant, i.e. if parsed correctly would each line in the CSV file always have the same number of fields?

 

[Azar]

i dont fully understand the question.
can you please elaborate?
if i understand correctly, you are asking if each line of data, or each row, has the same number of fields, or are broken down into the same number of columns?
each row has the same information and is 'text to columned' into the same number of columns....
example, the text has 5 separate information fields separated by a space, i move these 5 values into 5 different columns.

 

[shg]

<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1>

Are there commas separating the thousands in the CSV file?

yes

Comma-separated values means just that -- fields are delimited by commas. 100,000 is two values, 100 and 0.

You can change the extension to txt and import using the wizard, or eliminate the commas in numeric values in the CSV file.

 

[Greg Truby]

i dont fully understand the question.
can you please elaborate?
if i understand correctly, you are asking if each line of data, or each row, has the same number of fields, or are broken down into the same number of columns?
each row has the same information and is 'text to columned' into the same number of columns....
example, the text has 5 separate information fields separated by a space, i move these 5 values into 5 different columns.

If the fields are separated by a SPACE and not by commas, then do as shg has already suggested and just change the extension to TXT and import as space-delimited.

Otherwise, the nature of my question was to map out a solution that would recombine the numbers.

 

[Azar]

thanks everyone for your help.