Tuesday, July 2, 2024

Notepad ++ - How to Find special characters in data in notepad++

Why:

Sometimes integration fails for special characters in data which we can't see and its like a double space in data. 

If you are cutting and pasting from a text file, such as an XML file, you can find non-ASCII characters as

Follow below steps to find the special char:

  1. Open the file in Notepad++
  2. Click the ‘Search’ menu.
  3. Click ‘Find Characters in Range” (the last item in the list)
  4. Make sure “Non-ASCII Characters (128-255)” is selected (I think it is the default).
  5. Click ‘Find’.
  6. It will highlight the row where the special character is.
  7. Click ‘Close’ and the cursor will be place immediately after the special character if one is found. (cursor will return to where the search began if no special characters are found).
  8. If you hit ‘Backspace’ immediately after the search, a special character will expand into its character codes. Delete them and replace with the desired character.

No comments:

Post a Comment

Featured Post

OIC - Commonly Used XSLT Functions in Oracle Integration Cloud (OIC)

In Oracle Integration Cloud (OIC), the most commonly used XSLT functions are primarily focused on transforming, filtering, and manipulating ...