How to delete all characters after 1 character

Sarah Duong

As the title of the topic. I want to delete the characters after the | character and delete itself, then how?

 s.crepatte@online.fr: lionel0203 | 20
pep2000@free.fr: senna320 | 24
nicolas.gravier@online.fr: nicolas | 38
yannmarek@free.fr: vulpian | 96
pontclaix27@free.fr: 29111988 | 80
ol4l4@online.fr: necfe770 | 39
marc.gendreau@orange.fr: axel2005 | 19
jeanremaud@online.fr: jean1974 | 21
jo.lasvegas@free.fr: 8bdewgup | 5
fimaya@online.fr: julmat1 | 27
saurel.g@online.fr: mnegs01 | 23
jocelynoudot@orange.fr: jocelyn71 | 2
sebastienneuville@online.fr: chapuis | 24
francoiselemerrer@online.fr: mervat | first
pascal.ligney@sfr.fr: 04052002 | first
dalaihlama2@free.fr: satan666 | 12

and the result is :

s.crepatte@online.fr: lionel0203
pep2000@free.fr: senna320
nicolas.gravier@online.fr: nicolas
yannmarek@free.fr: vulpian
pontclaix27@free.fr: 29111988
ol4l4@online.fr: necfe770
marc.gendreau@orange.fr: axel2005
jeanremaud@online.fr: jean1974
jo.lasvegas@free.fr: 8bdewgup
fimaya@online.fr: julmat1
saurel.g@online.fr: mnegs01
jocelynoudot@orange.fr: jocelyn71
sebastienneuville@online.fr: chapuis
francoiselemerrer@online.fr: mervat
pascal.ligney@sfr.fr: 04052002
dalaihlama2@free.fr: satan666

Alan Kilborn

@Sarah-Duong

You probably also want to remove the space before the vertical bar as well?

Try this:

Find what box: (?-s) \|.+
Replace with box: Make sure this box is EMPTY !
Wrap around checkbox: ticked
Search mode radiobutton: Regular expression
Press the Replace All button