Save as comma csv problems

[rock]

Hello,

I hace Excel 2002.

I have near 6000 addresses and contacts and wish to save the xls to a
comma csv.

I have done that before and then imported the comma csv into my
membership program were it says 'import comma csv'.

The problem is that some (300 odd) of the records are not imported
correctly.

I think this maybe because here are some commas in some of the fields eg
24 my street, whatever.

Would that be the cause, and if so how can I get rid of all the commas?

Many thanks

rock

 

[Dave Peterson]

I bet it's the way that your membership program works.

I'd try this against a copy of the excel workbook (just in case!).

Change all the commas in the worksheet to a different character (a hyphen or a
space????).

Select a single cell
Edit|replace
what: ,
with: (whatever character you want)
replace all

Then save as a .csv and try importing it again.

 

[rock]

Many thanks Dave.

Worked well.

I guess it took all the commas in the field data as columns.

rock

 

[Dave Peterson]

It sounds like your program that imports the data doesn't know how to treat CSV
files--at least not the same way Excel treats them.

Excel would have put double quotes around any field with that separator.
Most/some programs are smart enough to know that it should be treated as a
single field.

But I guess not all programs work the same way <vbg>.