SQLTeam.com | Weblogs | Forums

Remove special characters from a flat file

i am trying to remove special characters from a entire flat file. i've created a function that once imported into a sql table i can apply the function to individual column. however i want to do a full scan on a flat file and remove. Please advise

please post sample file with special character?
Does not sound like a sql issue, maybe powershell or python.

if you want to do the cleanup in sql after you load data into sql, please post sample data


How are you importing the data into SQL Server? And what special characters do you need to remove - and why?

1 Like