Strip special characters in row of data

[vanikanc]

Hi, I am creating a comma separated file with data from database. The data is pretty much customer information. Is there a way to code for special characters, like commas with the customer data? Thanks!

[Lost User]

I'd recommend to encode it in Base64. That way you can even throw (binary) pictures in there.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]

[Ennis Ray Lynch Jr]

Surprisingly there is a standard for CSV. Text Fields are surrounding by "". " escapes ", pretty simple.

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost "All users always want Excel" --Ennis Lynch