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 | 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
    


  • @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


Log in to reply