[SOLVED] Delete lines with "|" and numbers from 0-10 at the end

georgi · 09-30-2013, 06:14 AM

Hi everybody,

I have a large file with some lines ending with "|" and numbers from 0-10 at the end and I want to delete them. Example

Code:

...|9

I have used successfully "sed" to delete all having numbers 0-9, but can not figure out how to also include 10. The command I use is

Code:

sed -i.bkup -e 's/|[0-9]//g' filename

Any help is greatly appreciated.

mina86 · 09-30-2013, 06:29 AM

Code:

sed -i.bkup -e 's/|[0-9][0-9]*$//g' filename

Also, do you want to delete the lines that match this or remove “|<number>” from the end of those lines? Your example command does the latter, for the former use either of:

Code:

sed -i.bak -e '/|[0-9][0-9]*$/d' filename

Code:

grep -v '|[0-9][0-9]*$' <filename >filename.new

syg00 · 09-30-2013, 06:38 AM

That will remove all two digit numbers as well, not just "|10".

Personally I would just add "-e '/s/|10$'//'

pan64 · 09-30-2013, 07:05 AM

you can use grouping:
sed -e 's/|$[0-9]\|10$$/d'

georgi · 09-30-2013, 08:22 AM

mina86, your first code works fine

Code:

sed -i.bkup -e 's/|[0-9][0-9]*$//g' filename

I just want to delete “|<number>” not the entire line.

syg00, adding your suggestion does not work

pan64, your suggestion comes with an error

Code:

sed: -e expression #1, char 19: unterminated `s' command

thanks everyone for the time and efforts. Appreciate your help

pan64 · 10-01-2013, 12:22 AM

sorry, this one should work:
sed -e 's/|$[0-9]\|10$$//g'