RegExp Help ^_^

[caramen]

Hello guys

I have a script to update and i am still a bit lost with regexp. Particulary when I have a big patterne like that :

 

$pattern = '(?s).+?(\d+)\]\[([^\]]+).+?Bonjour,\s+(.+?) vous envoie.+?email : (\N+).+?tél. : (\N+)'

$pattern = '(?s).+?(\d+)\]\[([^\]]+).+?Bonjour,\s+(.+?) vous envoie.+?email : (\N+)'

 

This is an exemple of what I want to exctract (I want blue values ) :

 

[BLABLA][60][Demandeur][4567_987654]

Bonjour,
Charles HENRY vous envoie un message.
J'ai un problème de toilette
Merci de m'aider
- email : Jordane.AutoIT@AutoITForum.com
- tél. : 0607080909

I had that and it was working very fine.

 

=============================================

 

Now my text content changed :

It's now like that :

 

[BLABLA][PO][60][Demandeur][4567_987654]

Bonjour,
Charles HENRY vous envoie un message.
J'ai un problème de toilette
Merci de m'aider
- email : Jordane.AutoIT@AutoITForum.com
- tél. : 0607080909

Or

 

[BLABLA][Autre][60][Demandeur][4567_987654]

Bonjour,
Charles HENRY vous envoie un message.
J'ai un problème de toilette
Merci de m'aider
- email : Jordane.AutoIT@AutoITForum.com
- tél. : 0607080909

 

For information :

BLABLA cannot change and will stay letters.

Autre or PO wont change

60 can be 01 to 980

 

Demandeur can be :

Demandeur Or Opérateur Or Pris Or Instructeur.

 

1000 thanks RegExp pro's

 

Edited April 2, 2019 by caramen

[FrancescoDiMuro]

@caramen
Maybe something like this?

#include <Array.au3>
#include <StringConstants.au3>

Global $strString = "[BLABLA][Autre][60][Demandeur][4567_987654]" & @CRLF & @CRLF & _
                    "Bonjour," & @CRLF & _
                    "Charles HENRY vous envoie un message." & @CRLF & _
                    "J'ai un problème de toilette" & @CRLF & _
                    "Merci de m'aider" & @CRLF & _
                    "- email : Jordane.AutoIT@AutoITForum.com" & @CRLF & _
                    "- tél. : 0607080909"
                    
Global $strPattern = "(?s)\[[^]]+\]\[[^]]+\]\[([^]]+)\]\[([^]]+)\]\[([^]]+)\].*?" & _
                     "Bonjour,\s*(.*?)(?=vous).*?" & _
                     "\-\s*email\s*:\s(\S+)\s*" & _
                     "\-\s*tél\.\s*:\s([^\n]+)"

Global $arrResult


$arrResult = StringRegExp($strString, $strPattern, $STR_REGEXPARRAYGLOBALMATCH)
If IsArray($arrResult) Then _ArrayDisplay($arrResult)

Edited April 2, 2019 by FrancescoDiMuro

[caramen]

Hey @FrancescoDiMuro Ho are you  ? Thanks giving me some if your time

 

I 'll try right now and let you know.

Edited April 2, 2019 by caramen

[caramen]

@FrancescoDiMuro Nop it does not work

My output is :

Name Surname | Email | Phone number | Po | Department

And i need :

Name Surname | Email | phone Number| Po | Folder number | Department

Edited April 2, 2019 by caramen

[FrancescoDiMuro]

@caramen
Post the string you are using, because the script with the previous string does what you expect.

Edited April 2, 2019 by FrancescoDiMuro

[caramen]

Sorry my bad bro.

 

I got correct input without PO or AUTRE

But seem like my boss ust said me we dont need it.

 

I am done with that regexp TY Mate.

 

I was forgetting this : $STR_REGEXPARRAYGLOBALMATCH

Edited April 2, 2019 by caramen

[caramen]

@FrancescoDiMuro I am sorry mate it s not working as expected but it's my fault ;

I forgot to say you :

My input $hString can be :

"[BLABLA][AUTRE][60][Demandeur] Autre" & @CRLF & @CRLF & _
"Bonjour," & @CRLF & _
"Charles HENRY vous envoie un message." & @CRLF & _
"J'ai un problème de toilette" & @CRLF & _
"Merci de m'aider" & @CRLF & _
"- email : Jordane.AutoIT@AutoITForum.com" & @CRLF & _
"- tél. : 0607080909"

In this case i have no digit apearing. And i have 0 output.

Phew it was my exemple to code it so i noticed that before leave this site.

 

Btw I am trying with 101 regexp but i non stop failing. I have no time to undertsand the correct syntaxt arfff

 

If it is possible for you to help me to make the pattern work for both possibility 😕 Man thanks again and sorry.

Edited April 2, 2019 by caramen

[FrancescoDiMuro]

13 minutes ago, caramen said:

"[BLABLA][AUTRE][60][Demandeur] Autre" & @CRLF & @CRLF & _

You should describe all the possible strings that could appear on there.

[caramen]

I thought i did at my first post Just forgot that i can have no digit i am sorry mate it's becose it's been a long i was not in this building so i forgot some details.

 

For your confort I will repeat and i hope i wont miss something :

 

[BLABLA][PO][60][Demandeur][4567_987654] Bliblo blop Random texte here
Bonjour,
Charles HENRY vous envoie un message.
J'ai un problème de toilette
Merci de m'aider
- email : Jordane.AutoIT@AutoITForum.com
- tél. : 0607080909

Or

[BLABLA][Autre][60][Demandeur][4567_987654]Random texte here
Bonjour,
Charles HENRY vous envoie un message.
J'ai un problème de toilette
Merci de m'aider
- email : Jordane.AutoIT@AutoITForum.com
- tél. :

Or

[BLABLA][Autre][60][Demandeur]Autre question
Bonjour,
Charles HENRY vous envoie un message.
J'ai un problème de toilette
Merci de m'aider
- email : Jordane.AutoIT@AutoITForum.com
- tél. : 0607080909

Or

[BLABLA][PO][60][Prise][4567_987654]Autre question
Bonjour,
Charles HENRY vous envoie un message.
J'ai un problème de toilette
Merci de m'aider
- email : Jordane.AutoIT@AutoITForum.com
- tél. :

 

For information :

Demandeur can be :

Demandeur Or Opérateur Or Prise Or Instructeur :

PO Can be PO or PSC Or AUTRE

The téléphone can be here or not.  (Already solved with string split)

Thanks mate 1000x !

Edited April 2, 2019 by caramen

[iamtheky]

If those strings, 'Bonjour' prior to the name and 'vous' after, are static then it makes it easier (at least for me) if all whitespace is removed.  The only other assumption is the capitalization of the first letter of the name, but you could always sanitize that line first.

#include<array.au3>

Global $strString = "[BLABLA][Autre][60][Demandeur][4567_987654]" & @CRLF & @CRLF & _
                    "Bonjour," & @CRLF & _
                    "Charles HENRY vous envoie un message." & @CRLF & _
                    "J'ai un problème de toilette" & @CRLF & _
                    "Merci de m'aider" & @CRLF & _
                    "- email : Jordane.AutoIT@AutoITForum.com" & @CRLF & _
                    "- tél. : 0607080909"


$aMatch = stringregexp(StringStripWS($strString , 8) , "\[.*?\]\[.*?\]\[(.*?)\]\[(.*?)\]\[(.*?)\]Bonjour,([A-Z].+?)([A-Z].+?)vous.*?email:(.*?)-tél.:(.*?)\z",3)

_ArrayDisplay($aMatch)

 

Edited April 2, 2019 by iamtheky
script rather than just regex

[caramen]

@FrancescoDiMuro

Edited April 2, 2019 by caramen

[caramen]

@iamtheky Ty man let me try. that.

 

I have all i want and the only thing missing is the file number.

And the Francesco pattern is working very fine expet if i have no digit inside the first line.

 

hmmm one min i com eback to say you.

[caramen]

@iamtheky Sorry dude it does not work at all.

>"C:\Program Files\AutoIt3\SciTE\..\autoit3.exe" /ErrorStdOut "C:\Users\yann.lebrun\Desktop\Nouveau AutoIt v3 Script.au3"    
>Exit code: 0    Time: 0.1185

I mean it does not work if there is no digit **

Edited April 2, 2019 by caramen

[iamtheky]

[caramen]

Bro this is already working. My issue is when the folder number is missing becose it happen sometime. Look above post you will see all case possible.

This is the non working case :

And i have to make these two case work With and without digit.

[BLABLA][Autre][60][Demandeur]Autre question
Bonjour,
Charles HENRY vous envoie un message.
J'ai un problème de toilette
Merci de m'aider
- email : Jordane.AutoIT@AutoITForum.com
- tél. : 0607080909

 

 

 

[caramen]

We can be in these cases :

 

[BLABLA][PO][60][Prise][4567_987654]Autre question

[BLABLA][PO][60][Prise]Autre question

[BLABLA][AUTRE][60][Prise][4567_987654]Autre question

[BLABLA][PO][60][Demandeur]Autre question

And the rest of the text and we have already a working pattern for this.

I tryed a lot of thing in regexp101 but i cant get so long syntaxt work for me even with the help of the website i am non stoping to try since 3 hours^^

 

Edited April 2, 2019 by caramen

[FrancescoDiMuro]

@caramen

Make that group optional adding a ? after the group

[caramen]

Just now, FrancescoDiMuro said:

@caramen

Make that group optional adding a ? after the group

ok 😛 i am trying now so give me one min^^

 

[caramen]

7 minutes ago, FrancescoDiMuro said:

@caramen

Make that group optional adding a ? after the group

Well i tryed all position for the "?" between each single characters and nop nothing is extracted

 

Maybe i can ubund the total line after a string split and if ubund = > 4 then i get the last bracket ?

I would prefer a regexp but seem like it doesn't come

Edited April 2, 2019 by caramen

[iamtheky]

 I am not attempting to question the efficacy of your chosen path, nor generate a solution.  Just trying to show you how to make things optional inline, which is easier to highlight in this fashion.  Is this closer to feasible for an example?

#include<array.au3>



Global $strString2 = "[BLABLA][Autre][60][Demandeur][4567_987654]" & @CRLF & @CRLF & _
                    "Bonjour," & @CRLF & _
                    "Charles HENRY vous envoie un message." & @CRLF & _
                    "J'ai un problème de toilette" & @CRLF & _
                    "Merci de m'aider" & @CRLF & _
                    "- email : Jordane.AutoIT@AutoITForum.com" & @CRLF & _
                    "- tél. : 0607080909"

Global $strString3 = "[BLABLA][Autre][60][Demandeur]autere" & @CRLF & @CRLF & _
                    "Bonjour," & @CRLF & _
                    "Charles HENRY vous envoie un message." & @CRLF & _
                    "J'ai un problème de toilette" & @CRLF & _
                    "Merci de m'aider" & @CRLF & _
                    "- email : Jordane.AutoIT@AutoITForum.com" & @CRLF & _
                    "- tél. :"


Global $strString4 = "[BLABLA][Autre][60][Demandeur]" & @CRLF & @CRLF & _
                    "Bonjour," & @CRLF & _
                    "Charles HENRY vous envoie un message." & @CRLF & _
                    "J'ai un problème de toilette" & @CRLF & _
                    "Merci de m'aider" & @CRLF & _
                    "- email : Jordane.AutoIT@AutoITForum.com" & @CRLF & _
                    "- tél. : "



$aMatch = stringregexp(StringStripWS($strString2 , 8) , "\[.*?\]\[.*?\]\[(.*?)\]\[(.*?)\]\[*(.*?)\]*?Bonjour,([A-Z].+?)([A-Z].+?)vous.*?email:(.*?)-tél.:(.*?)\z",3)

_ArrayDisplay($aMatch)