Remove special characters while moving data from SQL to CSV

While fetching data from database, you can simply insert below logic to remove special character from String and then insert modified data in CSV:

>>> string = "All Special $#! character     888323"
>>> ''.join(e for e in string if e.isalnum())
'AllSpecialcharacter888323'

OR

You can also use regex to remove special characters-

Here is a regex to match a string of characters that are not a letters or numbers:

[^A-Za-z0-9]+
Here is the Python command to do a regex substitution:

regex.sub('[^A-Za-z0-9]+', '', string)