embedded character with reversed background

98 Views Asked by At

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.

1

There are 1 best solutions below

1
On BEST ANSWER

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.