SQLTeam.com | Weblogs | Forums

Need C# Script to remove special characters

Need C# code for script task to remove double quotes within a string in CSV file.
e.g New " code need to remove double quotes and replace with space and trim.
And remove break at the end of string.

please see below links .. hope these help :slight_smile:

there are other ways besides C# code .. if C# code is not absolutely necessary

https://social.msdn.microsoft.com/Forums/en-US/de6d5655-f1ef-4e93-a753-4413e1e40e23/removing-the-double-quotes-from-a-csv-file

C# code
https://code-examples.net/en/q/11fe15