multiple txt to one new txt

pinuzzu99

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 …

guy038

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

pinuzzu99

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

pinuzzu99

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

Alan Kilborn

@pinuzzu99

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

pinuzzu99

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

guy038

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

pinuzzu99

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

guy038

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

pinuzzu99

thanks you so much, again! cheers