Community
Showing results for 
Search instead for 
Do you mean 
Reply

Clean up comma's in some fields ?

Copper Contributor
Posts: 90
Country: Netherlands

Clean up comma's in some fields ?

For later exporting in csv files, I like to Clean up comma's in some fields :

 

Stationstreet, No 9

 

Water,Milk,Butter

 

Best would be to replace the comma by make that place in the field as empty, so comma becomes a space.

I have to many contact fields/ Udef fields to do it manually.

Uptill now a choose a field "contains ,  "  and then do it per field,but too much work for 5000 plus fields.!

 

Any Idea ??

William

 

Platinum Elite Contributor
Posts: 6,662
Country: USA

Re: Clean up comma's in some fields ?

Don't waste your time. The ACT!  text delimited export for comma dilimited is quote/comma delimited. That is each fields text is enclosed in quotes and most programs that accept comma delimited data will treat the data enclosed by quotes as literal and will ignore any commas in the field data.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129