Doubt with REGEX, I can't find the correct pattern

[RPASOFT]

Hello, I need to find the regex to locate the following data 01597532R, thanks for the help

NIF. B00000000 9541
EMPRESA DOMICILIO Nº INS. S.S.
tu empresa , S.L. CL 00/0049547-23
TRABAJADOR/A CATEGORIA NºMATRIC ANTIGUEDAD D.N.I.
APELLIDO APELLIDO, NOMBRE ESPECIALIA 16 SEP 23 01597532R
Nº AFILIACION. S.S. TARIFA COD.CT SECCION NRO. PERIODO TOT. DIAS
41/74859679-94 9 258 254 MENS 01 ENE 22 a 31 ENE 22 31
CUANTIA PRECIO CONCEPTO DEVENGOS DEDUCCIONES

[ppr (Peter Preuss)]

Regex is about patterns. And in Patterns we can try to make them more solid, when some reliable structure details can be added.

Without any other info we can try:

have a look below and check for the SOP, which is about to give us more details for a better support

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…

and also:

[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…

[RPASOFT]

@RPASOFT

NIF. B00000000 9541
EMPRESA DOMICILIO Nº INS. S.S.
tu empresa , S.L. CL 00/0049547-23
TRABAJADOR/A CATEGORIA NºMATRIC ANTIGUEDAD D.N.I.
APELLIDO APELLIDO, NOMBRE ESPECIALIA 16 SEP 23 01597532R
Nº AFILIACION. S.S. TARIFA COD.CT SECCION NRO. PERIODO TOT. DIAS
41/74859679-94 9 258 254 MENS 01 ENE 22 a 31 ENE 22 31
CUANTIA PRECIO CONCEPTO DEVENGOS DEDUCCIONES

Thank you, that worked for me, but I have found another case, it can be sometimes that record starts and ends with a letter, how would the regular expression be for both X0000000V and 000000000V

[RPASOFT]

Thank you, that worked for me, but I have found another case, it can be sometimes that record starts and ends with a letter, how would the regular expression be for both X0000000V and 000000000V

[RPASOFT]

It worked for me like this [A-Z]\d+[A-Z]|\d+[A-Z]

[Gokul001 (Gokul Balaji)]

Hi @RPASOFT

@RPASOFT

[A-Z]\d+[A-Z]|\d+[A-Z]

You can try this pattern also

User assign activity

LHS → Create an variable
RHS → System.Text.RegularExpressions.Regex.Match(“Input string”,“[A-Za-z]\d+[A-Za-z]|\d{2}\d+[A-Za-z]”).Tostring

Regards
Gokul