Extract specific word

Help Something Else
1

Hello everyone,

i would like to extract in this sentence many things with Regex :
[EXTIA][IDF-IT] Demande de contrat SST Julie PAOLUCCI Ayoub GHAMMOURI (GHAMMOURI AYOUB) @ENEDIS GTAR 06/05/2024

I would like to extract :
1°) [EXTIA][IDF-IT]
2°) Julie PAOLUCCI
3°) Ayoub GHAMMOURI
4°) ENEDIS
5°) 06/05/2024

All the words below can change from one email to another, so the variables must be “dynamic”.

Thank you for your help

Maxime

2

Hi @Maxime_LAUGIER If the texts you would like to extract would be in same position and always separated by spaces, I think it would be easier to extract by splitting that sentence using space

3

Hello @avejr748

Exactly

4

But with Regex, how can i do this?

5

Hi @Maxime_LAUGIER

Try this:

Assign -> Input = "[EXTIA][IDF-IT] Demande de contrat SST Julie PAOLUCCI Ayoub GHAMMOURI (GHAMMOURI AYOUB) @ENEDIS GTAR 06/05/2024"

Find Matching Patterns activity
Pattern: "(\[[A-Z].*\])|((?<=[A-Z]+\s+)[A-Za-z]+\s+[A-Za-z]+)|((?<=\)\s+\@)[A-Z]+)|(\d+\/\d+\/\d+)"
Pattern Options: Compiled
Text to Search in: Input
Result: Matches

For Each currentMatch in Matches
    Assign -> currentMatch.ToString
End For Each

Sequence8.xaml (9.1 KB)

Output:
image

image
image1547×791 50 KB

Regards

6

Thank you,

It’s works really fine.
And now, i would like to put this value in the Output in a specific row in excel, how can i separate this value?

Thanks again

7

Hello,

do you have any ideas for seperate the value at the Output as variables to add them in a specific cell in excel?

Thanks

8

Hi @Maxime_LAUGIER

Check the below workflow:
SampleProcess6.zip (48.8 KB)

Output:
image

Regards

9

Hello @vrdabberu ,

It’s works,
Thank you so much

10

Hi @Maxime_LAUGIER

You’re welcome.

Happy Automation !!

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.