Replacing last character at the end of each line in a file

Question

I have a file with the format:

abc!12345th!
bcv!2345568790hg!
fjldslj12123344!!flgnjlk!

I was trying to figure out how to remove the ! symbol at the end of each line. I tried using "Find and replace" in Notepad++ but it didn't work. Any ideas on this one?

Answer 1

In Notepad++, press Ctrl-H (Replace...). In the Replace dialog box, click Extended under Search Mode. In the "Find what" box type !\r and in the "Replace with" box type \r. Then click Replace All.

To make this work for all lines in the file, you need to make sure that the last line is blank (you can remove the blank line later if you wish). Or manually edit the last line.

Depending on the file you might need to use \n instead of \r.

Answer 2

If you have it in every line try this:

1. ctrl+h

2. check regular expression and use this below expression:

   .{1}$
   

3. Let Replace with Empty

4. Click Replace All in the right.

Answer 3

Find and Replace !\n with \n in Extended mode in Notepad++.

Answer 4

Here is a way to go:

• Ctrl+H
• Find what: .$
• Replace with: EMPTY
• Replace all

Explanation:

.   : 1 any character
$   : end of line

You could use ! instead of . if you want to remove only ! but not other character, or a character class if there are some different characters to remove for example [!;:]

• Find what: !$
• Find what: [!;:]$

DO NOT CHECK . matches newline

Result for given example:

abc!12345th
bcv!2345568790hg
fjldslj12123344!!flgnjlk

Answer 5

I have a CSV file, and the following worked for me:

Find and replace !\r\n with \r\n