Issue with building a CSV file

Occasional Visitor

Dear,

 

For a government tool I need to create a CSV file to import data. I am using Visual Basic to create the import CSV. The issue I have is the following:

 

Some of the data is fixed, some is transactional. In the fixed data there is a text string with a comma in it "Without Flowers, With Plants". If I build my CSV string in a regular way (stringCSV = stringCSV & "Without Flowers, With Plants;", I have an incorrect CSV, because than the file won't split to columns anymore. I already tried to use double quotes: """Without Flowers, With Plants"";" but the issue stays.

 

Hopefully there is a good solution for this that I don't see right now.

0 Replies