Need help me with that file to build a good regex plz?

Hello,

Can you help me with that file to build a good regex plz ?

i built a regex for everything except what I have surrounded :

Hello @Soudios To maintain clean learning environment, kindly show us what you have tried so far.

@AkshaySandhu

Yes of course, i used that regex:

Contact :
(?<=Contact : ).*

TĂ©l :
(?<=TĂ©l. : )[0-9 ]+

Portable :
(?<=Portable : )[0-9 ]+

Fax :
(?<=Fax : ).*

Email :
(?<=E-mail : ).*

1 Like

Hello @Soudios here you go…
(TĂ©l[\s\S]*?)Historique
use this pattern and let us know if it works for you or not…
if it is not working then please give sample text.
Test.xaml (6.1 KB)

Hi @AkshaySandhu
This is not working for me, i want what is after ''Historique"

Hello @Soudios,

Regex for Historique:-
(?=Historique)[A-Za-z\s:0-9()-,]+(?=))

Thanks & Regards,
Raj Parsana

2 Likes

Not working good

This is the sample text :slight_smile:
Ain (01)
22 brasseries

IUT Lyon 1 - Site de Bourg-en-Bresse
Rue Henri de Boissieu 01000 BOURG-EN-BRESSE

TĂ©l. : 04 74 45 52 65 Fax : 04 74 45 52 01
Portable :
Contact : Claude Noel (chef de département de Génie Biologique de l’IUT Lyon 1)
E-mail : iutbourg.bio@univ-lyon1.fr
Site web : iut.univ-lyon1.fr
Historique
Création : septembre 2008
Pas d’historique de production pour cette brasserie

104 Emmanuel Gillard | Projet Amertume (http://projet.amertume.free.fr)La bière en France Edition 2020

du Bugey
Lacoux 01110 HAUTEVILLE-LOMPNES

TĂ©l. : Fax :
Portable : 06 67 36 43 36
Contact : Ludwig de Belvalet
E-mail : ludwig.debelvalet@gmail.com
Site web : la-biere-du-plateau.webnode.fr
www.facebook.com/brasseriedubugey
Historique
Création : mars 2017
La gamme de bières était brassée entre juin 2009 et décembre 2014 par La Bière du Plateau (Hauteville-Lompnes, FR), puis par La
Jacquerie (Conzieu, FR) entre décembre 2014 et mars 2017
Historique de production (1) prévision (2) estimation
2017 : 60 hl
2018 : 72 hl
2019 : 80 hl (1)

1 Like

Hello @Soudios,

Use this (?=Historique)[A-Za-z\n\Ă©\s:0-9 PUT YOUR WORDS HERE ]+(?=))

Thanks & Regards,
Raj Parsana

2 Likes

i can’t put all the words here because there are 1000 pages

1 Like

It’s some different language so put that letters, I am not able to type using my keyboard.

2 Likes

Hello

Have a look at this solution:
(?<=www.facebook.com/.*\nHistorique)[\s\S]+

It will work as long as the “www.facebook.com” is always constant.

1 Like

@Steven_McKeering

Hi,

Thank you for your response but “www.facebook.com" is not always constant.
We need to find something else :slight_smile:

You can find here the output : output.txt (9.9 KB)

Also, the pattern does’nt work for me :

Hello

It won’t work in Regex101.com because its not a perfect match to UiPath’s language. It will work in UiPath :slight_smile:

Hmmm I need more information on the pattern.

What more can you tell me about it?