Hi I'm editing a csv file to use in my database. From some weeks when I open it with notepad++ I'm finding a bad characters at the end that broken my file like a CR.
I.e
"30-APR-2014","ELCO, ELCO","ELCOCESARBAD
Where bad is with black background (I have activate see all characters"
Anyone know how to solve it ?
Inserting ASCII characters To insert an ASCII character, press and hold down ALT while typing the character code. For example, to insert the degree (º) symbol, press and hold down ALT while typing 0176 on the numeric keypad. You must use the numeric keypad to type the numbers, and not the keyboard.
You can download Notepad++ and open the file there. Then, go to the menu and select View->Show Symbol->Show All Characters . All characters will become visible, but you will have to scroll through the whole file to see which character needs to be removed.
How to view hidden characters in Notepad++ Go to View Menu > Select Show Symbol > Select Show All Characters . It displays all hidden characters in the opened file.
The problem can occur during operations like Replace
where an auto-backup happens mid operation. The solution is to disable auto-backup.
Settings
> Preferences
> Backup
> Uncheck Enable session snapshot and periodic backup
[Credit to Ujjwal Singh for the solution]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With