Concatenate Regex

[Luan]

Hey ! Dear, I need help with Matches(Regex), I want to concatenate Regex.
example of the result I’m looking for:

P111132HLote: 002/21
D44730BLote: 005/22
D44810BLote: 050/21…

below follows the flow
Sequência.xaml (10.2 KB)

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Luan what is input please give input as well so i can design something

[Gokul001 (Gokul Balaji)]

Hi @Luan

Welcome back to community

Regards
Gokul

[Gokul001 (Gokul Balaji)]

(?<=Lote:\s)\d.+(?=\sQtd)

@Luan

[Luan]

@raja.arslankhan
“P112033I CEVAC BRON 120L 2500D/2R BR
LOTE: 001/21 Val.: 2023-02-28
Lote: 001/21 Qtd: 40.000 Fab: 28/02/2021 Val: 28/02/2023 PMC: 0.00
D57820B CEVAC DIL. OCULAR 30ML
LOTE: 005/22 Quant.: 250.0000 Fabr.: 2022-05-09 Val.: 2025-03-28
Lote: 005/22 Qtd: 250.000 Fab: 09/05/2022 Val: 28/03/2025 PMC: 0.00
D57830B CEVAC DIL. OCULAR 60ML
LOTE: 006/21 Quant.: 10.0000 Fabr.: 2021-10-08 Val.: 2024-08-11
Lote: 006/21 Qtd: 10.000 Fab: 08/10/2021 Val: 11/08/2024 PMC: 0.00
E57630D CEVAC IBRAS L 10000D BR
LOTE: 001/22 Quant.: 20.0000 Fabr.: 2022-02-10 Val.: 2022-09-30
Lote: 001/22 Qtd: 20.000 Fab: 10/02/2022 Val: 30/09/2022 PMC: 0.00
P111132H CEVAC MASS L 2500D
LOTE: 002/21 Val.: 2022-07-30
Lote: 002/21 Qtd: 40.000 Fab: 28/02/2021 Val: 30/07/2022 PMC: 0.00
Vl. Aprox. Trib: 72,52
30024270 040 5102 UN 40,00 13,48 539,20 0,00 0,00 0,00 0 0
D44730B CEVAC MG-F 2000D BR
LOTE: 005/22 Quant.: 20.0000 Fabr.: 2022-06-01 Val.: 2024-04-
Lote: 005/22 Qtd: 20.000 Fab: 01/06/2022 Val: 30/04/2024 PMC: 0.00
D44810B CEVAC S.GALLINARUM BR
LOTE: 050/21 Quant.: 100.0000 Fabr.: 2022-02-04 Val.: 2023-12-
Lote: 050/21 Qtd: 100.000 Fab: 04/02/2022 Val: 07/12/2023 PMC: 0.00
B430H1BR VECTORMUNE FP MG 1000 D
LOTE: 003/21 Val.: 2023-06-16
Lote: 003/21 Qtd: 50.000 Fab: 16/06/2021 Val: 16/06/2023 PMC: 0.00”

this is the regex formula i am using
\b[A-Z]\d{5,6}[A-Z]\b|\b[A-Z]\d{3,4}[A-Z].BR.|Lot:…[/]…
for logging D44730B Lot: 005/22

[Luan]

@Gokul001
Hello there are two matches I want to pull the follow expression
1 -“\b[A-Z]\d{5.6}[A-Z]\b|\b[A-Z]\d{3.4}[A-Z].BR.”(D44730B )
2- “|Lot:…[/] …”(Lot: 005/22)

I want to concatenate the two in like this: D44730BLote: 005/22

[supermanPunch (Arpan)]

Hi @Luan ,

Try using the Below Regex Expression :

((\b[A-Z]\d{5,6}[A-Z]\b)|(\b[A-Z]\d{3,4}[A-Z].BR.))(.*\n)*?(Lote:*...[/]*....)

You would need to access the Groups 1 and 5 and concatenate them as shown below :

Output :

[Luan]

@supermanPunch
Thanks !
Do you have any material to indicate to work with Matches in uipath?

[supermanPunch (Arpan)]

@Luan ,

You could check the below posts on working with Regex Expressions. Mainly we need to work on the expression generation pattern, the activity simply captures what we have devised in the expression :

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…