How to delete all characters after 1 character
-
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 | 12and 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 -
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login