Remove special characters from a flat file

Transact-SQL
1

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

2

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

2 Likes
3

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

1 Like