Ho to extract a list of strings beginning by "-XX." from a string

[nSangui]

Hi,

I write this post because I’m trying to extract a list of strings from a big scraped text.

Mi text is like this

GQS864DFQS654DF FGHSF654GREGSRG SThstrgS654DGSERG
qgverfqze5 f4ze6f84qz6ef4qs -XX.YYYYYYYYYY qzefzfqzef qq86r4gfq6
fqzefqzefqzef46584qf -XA.YYYYYYYYYY 46 6ef84q6ze4 qzef8q6z
-XY.YYYYYYYYYY qf56er5fqef54 qf65q4ze6fq6 qz6f54z6efqzf6
56seg4r66e5 s6er5g6se5 se6gr5s6eg -XY.YYYYYYYYYY

I want to extract a list of strings with only the .XX-YYYYYYYYYY and .XY-YYYYYYYYYY values contained in the text. The value of YYYYYYYYYY il always different (numbers), the only pattern is .XY- and .XX- ( X and Y they also be numbers)

Thanks a lot for your solutions

Regards

[reda (Reda_Marzouk)]

Hi @nSangui

To do this you need to use a regex expression in a matches activity :

Input : GQS864DFQS654DF FGHSF654GREGSRG SThstrgS654DGSERG
qgverfqze5 f4ze6f84qz6ef4qs -XX.YYYYYYYYYY qzefzfqzef qq86r4gfq6
fqzefqzefqzef46584qf -XA.YYYYYYYYYY 46 6ef84q6ze4 qzef8q6z
-XY.YYYYYYYYYY qf56er5fqef54 qf65q4ze6fq6 qz6f54z6efqzf6
56seg4r66e5 s6er5g6se5 se6gr5s6eg -XY.YYYYYYYYYY

Patterns : -[0-9]{2}\.[0-9]{10}

Result : create a variable inside it using ctrl + k .

Regards,
Reda