'embedded character with reversed background

there are 'j' character that looks like this https://su-support.tinytake.com/msc/Njc2MjcwM18xOTM3OTc0Mg causing issues when importing into db. how to remove these at once?

i unchecked all options like this https://su-support.tinytake.com/msc/Njc2MjczMl8xOTM3OTc4Ng but it still appears

thank you.

characteremeditor


Solution 1:[1]

The Inverted J is the Line Feed (LF) character. You can remove these by selecting the Remove Embedded Newline Characters command. You can find this command on the Edit menu - CSV - Convert to, or the Help menu - Search Commands.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Yutaka

Related Questions