Extract a specific part from a string

What I am trying to do here is extract a specific part from a long string
so
Example : IVA COM. VENTAS DEBITO / 176695266 TERMINALES PUNTO DE VENTA
Result : 176695266
before each number there will always be “/” but after the number the characters can change

Thanks to you all for your responses in advance !!

hi @Ivan_torres_oliva

kindy try it
variable1 = yourTextVariable.Split("/“c)(1).ToString
yourTextVariable = yourTextVariable.Split(” "c)(1)
here i attached an example to your better comprehension.
Example.xaml (4.9 KB)

Regards!

Hi, thanks for your answer, try what you mentioned but I have a problem

Example : IVA COM. VENTAS DEBITO / 176695266 TERMINALES PUNTO DE VENTA
Result : 176695266

Until there everything goes well, what I want is extracted

Example : CUOTA TRANSACCION EXITOSA / 006695266 EN TERMINAL PUNTO DE VENTA (TPV)
Result : 006695266 EN

here it no longer brings me only the numbers since there is a different word after the numbers

it works for me


Example.xaml (4.9 KB)

check

or if it works, thank you very much friend

1 Like

mark as solution
cheers!

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