>Our client(s) is send us CSV files with demographics of people they serve. The problem is that a few of the rows in the CSV have names and/or addresses with embedded comma in them. This is throwing the APPEND a problem. The wrong data is ending up in the wrong columns.
>Can anyone suggest how to prevent this from happen at my end.
Hi,
Would you be able to show us such a line? and mark which embedded comma troubles you?
Would be achallenge to construct a code around this.
Rgds,
Koen