Remove special characters from CSV file using Notepad++
You will typically face issues when trying to upload CSV files into your applications. The application will start crying because there are some special characters in CSV file that are not visible to the naked eye. Here are the steps to remove special characters from CSV files using Notepad++ 1. Open CSV file in Notepad++ 2. Ctrl H will bring up the Search & Replace dialog 3. At the bottom of the dialog, choose 'Regular expression' instead of 'Normal' search mode 4. In Find What use this regex - [^0-9+&()_²A-Za-z,\n /.-] 5. In Replace With, put a space or any character you want to see in the file Test out your particular scenario by doing a few 'Find Next' to ensure any valid characters are not replaced. If you want to exclude more characters you find in your file, add them to the regex above. If you do not want to exclude certain characters from your file, remove them from the regex I have provided above. i.e. maybe you do not want '&' to a...