multiple txt to one new txt



  • works well with (on reg ex):
    find what: (?-s)^(?!\h*\w+@).
    replace with:

    bt some mail is of the type:
    name.gress@mail.com
    and the first part of the email is deleted (in this specific case the term “name”)…
    how to leave full email address?



  • I have found this that serves my purpose:
    \S+?@\S+?.\S+
    this regex select all my address@mail.com:numberletters

    now i would like to add part of string to delete the rest of the text in my txt…



  • Hello, @pinuzzu99 and All,

    Well, it’s just up to you ! All your previous e-mail addresses did not contain any dot before the @ char. Thus, I supposed that there were only word characters !

    With , your last example name.gress@mail.com, of course, the regex S/R should become :

    SEARCH (?-s)^(?!\h*[\w.]+@).+\R

    REPLACE Leave EMPTY


    Then, you said :

    now i would like to add part of string to delete the rest of the text in my txt

    I’m sorry but it’s really not clear to my mind !

    Please, give us a sample of your input text, with various e-mail adresses and show us the output text you are expecting to, from your present input example !


    Just a hint : when replying, type your input and output text as code, using the symbol </> , as below :

    See you later,

    Cheers,

    guy038



  • you are very kind of you. this is little extract of my txt file

    .: data :.
    =================================
    asda pamfhdjosa.mardedyly@ydefgo.com:cloggr4trr
    =================================
     
    ubba:/my-wallets.zip                               379912     2019-08-07T02:52:11+02:00
    .: data :.
    =================================
    asda cartgrtgrg@gfgbil.com:1r5yyr78115
    Pry Statinf: Kree
    =================================
     
    ubba:/crypto.zip                                   380547     2019-08-07T02:50:07+02:00
    .: data :.
    =================================
    asda jatrhtrh@grthil.com:mrthhrhmm17
    Pry Statinf: Kree
    =================================
     
    ubba:/wallets.zip                                  379807     2019-08-07T02:58:33+02:00
    .: data :.
    =================================
    asda lathmhjm@hhhjail.com:p456456inha
    Pry Statinf: Kree
    

    i want delete all text and line except
    mail.address@mail.com:xxxxxxxx

    with your string not work for me.
    work with (?-s)^(?!\h*[\w.]+@).
    but i have this result:

    
    
     pamfhdjosa.mardedyly@ydefgo.com:cloggr4trr
    
    
    
    
    
     cartgrtgrg@gfgbil.com:1r5yyr78115
    
    
    
    
    
    
     jatrhtrh@grthil.com:mrthhrhmm17
    
    
    
    
    
    
     lathmhjm@hhhjail.com:p456456inha
    
    

    empty line between emails and also one space before any mail address.
    I hope it helps me to complete the correct string!



  • Hi, @pinuzzu99 and All,

    Ok ! So, assuming your short example, below :

    .: data :.
    =================================
    asda pamfhdjosa.mardedyly@ydefgo.com:cloggr4trr
    =================================
     
    ubba:/my-wallets.zip                               379912     2019-08-07T02:52:11+02:00
    .: data :.
    =================================
    asda cartgrtgrg@gfgbil.com:1r5yyr78115
    Pry Statinf: Kree
    =================================
     
    ubba:/crypto.zip                                   380547     2019-08-07T02:50:07+02:00
    .: data :.
    =================================
    asda jatrhtrh@grthil.com:mrthhrhmm17
    Pry Statinf: Kree
    =================================
     
    ubba:/wallets.zip                                  379807     2019-08-07T02:58:33+02:00
    .: data :.
    =================================
    asda lathmhjm@hhhjail.com:p456456inha
    Pry Statinf: Kree
    

    The following regex S/R :

    SEARCH (?-s)^(?!\h*[\w.\x20]+@).*\R?

    REPLACE Leave EMPTY

    gives this output text :

    asda pamfhdjosa.mardedyly@ydefgo.com:cloggr4trr
    asda cartgrtgrg@gfgbil.com:1r5yyr78115
    asda jatrhtrh@grthil.com:mrthhrhmm17
    asda lathmhjm@hhhjail.com:p456456inha
    

    Are you expecting this result ?

    I simply suppose that the non-null part of an e-mail address, located before the @ char, may contain :

    • Any word character

    • A dot symbol

    • A space character

    Best Regards,

    guy038



  • thank you very much. excellent result. I’d still like if you could also delete the first part of the text in front of the email from:
    asda address@mail.com: mrthhrhmm17
    until you get:
    address@mail.com: mrthhrhmm17
    this of course for all the email addresses listed …



  • Hi, @pinuzzu99 and All,

    No problem ! If we assume that there are no space char in e-mail addressses ( generally the case ! ) and further on, in current scanned line, we just need to add an alternative which, implicitly, looks for lines with an e-mail address and deletes from beginning of current line till a non-null range of space characters. Thus, the following regex S/R :

    SEARCH (?-s)^(?!\h*[\w.\x20]+@).*\R?|^.*?\x20+

    REPLACE Leave EMPTY

    And you’ll obtain your expected result :

    pamfhdjosa.mardedyly@ydefgo.com:cloggr4trr
    cartgrtgrg@gfgbil.com:1r5yyr78115
    jatrhtrh@grthil.com:mrthhrhmm17
    lathmhjm@hhhjail.com:p456456inha
    

    Best Regards,

    guy038



  • oh yes! finally what i wanted!
    thank you very much, dear guy038.



  • another little help:
    i have another txt with text like this:

    ladgdfg_jfdggs@yertynno.com.vn:1234556:1654473467:53687091200
    jegfa@nkcore.com:jeryr55673:1757810123:53687091200
    ghyfm36@rocgfhmmail.com:mintgg18509:11767409268:53687091200
    v7cifgthhy@yasbco.com.tw:512454215:380488:53687091200
    

    i need have like this:

    code_text
    ladgdfg_jfdggs@yertynno.com.vn:1234556
    jegfa@nkcore.com:jeryr55673
    ghyfm36@rocgfhmmail.com:mintgg18509
    v7cifgthhy@yasbco.com.tw:512454215
    

    i want delete all :number:number



  • @pinuzzu99

    What have you tried?
    What did you get?
    What didn’t work about it?



  • which regex is needed to eliminate :number:number at the end of each line



  • Hi, @pinuzzu99 and All,

    Nice ! I even succeded to merge your two kinds of text, by adding a third alternative in the search regex !


    So, starting with the input text, below, where the e-mail adresses may be :

    • Preceded with any chars ( asda, 12345 …), followed with, at least, one space char OR beginning the line

    • Followed with, at least, one field, determined by a colon separator char

    bla bla blah
    bla bla blah
    bla bla blah
    asda ladgdfg_jfdggs@yertynno.com.vn:1234556:1654473467:53687091200
    bla bla blah
    bla bla blah
    jegfa@nkcore.com:jeryr55673:1757810123:53687091200
    bla bla blah
    bla bla blah
    12345      ghyfm36@rocgfhmmail.com:mintgg18509:0000000000000:1111111111:55555555555555:777777777777777777:99999999999
    bla bla blah
    bla bla blah
    bla bla blah
    asda           v7cifgthhy@yasbco.com.tw:512454215:380488:53687091200
    

    Use the following regex S/R :

    • SEARCH (?-s)^(?!\h*[\w.\x20]+@).*\R?|^.*?\x20+|.+?:.+?\K:.+

    • REPLACE Leave EMPTY

    • Of course, the Regular expression search mode is selected and the Wrap around option is ticked

    • You must use the Replace All button, exclusively ( Not the Replace button ! )

    We get the following output text :

    ladgdfg_jfdggs@yertynno.com.vn:1234556
    jegfa@nkcore.com:jeryr55673
    ghyfm36@rocgfhmmail.com:mintgg18509
    v7cifgthhy@yasbco.com.tw:512454215
    

    Notes :

    This regular expression is composed of 3 alternatives :

    • The first part (?-s)^(?!\h*[\w.\x20]+@).*\R?, which have been explained previouly. If deletes any entire line, which does not contain a @ char, after a non-null range of words chars and possible dot and/or space chars

    • The second part ^.*?\x20+ which deletes all text between beginning of line and a non-null range of space characters, if that line contains an e-mail address, further on

    • The third part .+?:.+?\K:.+ deletes, after the e-mail adress, from the second : char found till the last standard char of the current scanned line

    • Note, in this last part, the use of the lazy quantifier +? to identify all standard chars between the first and the second : chars and the \K syntax before the second : char, which resets the overall search and just grabs all the remaining chars of current line, from the second :, included


    Remark :

    I strongly advice you to learn the regular expresions world ! Of course, you’ll have to study for 1/2 months, but it’s really worth it ;-)). To begin with, consult this FAQ :

    https://community.notepad-plus-plus.org/topic/15765/faq-desk-where-to-find-regex-documentation

    Best Regards,

    guy038



  • ohhhhh very great! many thanks for your help! very very thanks.
    and you’re right when you say you have to study. and usually I do. but in the case of np ++ using little, it did not occur to me to search and learn reg ex expressions. but I will take your suggestion into account.

    for my question: this is ANOTHER txt, then different. but anyway you code work great, my intent was that! very very many thanks for your help!
    Regards



  • Hi, @pinuzzu99,

    Ah, OK ! So, if we consider that there were 2 separate tasks and starting with your exact input text, below :

    ladgdfg_jfdggs@yertynno.com.vn:1234556:1654473467:53687091200
    jegfa@nkcore.com:jeryr55673:1757810123:53687091200
    ghyfm36@rocgfhmmail.com:mintgg18509:11767409268:53687091200
    v7cifgthhy@yasbco.com.tw:512454215:380488:53687091200
    

    The following regex S/R :

    • SEARCH (?-s)^.+?:.+?\K:.+

    • REPLACE Leave EMPTY

    • Click on the Replace All button, exclusively

    should leave you with your expected result :

    ladgdfg_jfdggs@yertynno.com.vn:1234556
    jegfa@nkcore.com:jeryr55673
    ghyfm36@rocgfhmmail.com:mintgg18509
    v7cifgthhy@yasbco.com.tw:512454215
    

    Cheers,

    guy038



  • thanks you so much, again! cheers


Log in to reply