How to extact particular number from cell

[Neeta_Latwal]

How to extract 7 digit number placed before -firm paid, please help

00124565-1111225-1234567-firm paid

00124565-1234567-firm paid

00144565-1111227-1234567-2234568-firm paid

00144565-2234568-firm paid

[JS1989]

Hey please try this, hope this helps :)

[p-g]

You can leverage RIGHT and LEFT Functions in Formula Tool. Left(Right([Field1],17),7)

[kamal03]

Hi @Neeta_Latwal ,

There can be multiple ways to do this one of them is to use the RegEx tool.

Please try the below workflow using this expression:--

(\d{7})(?=-firm paid)

[p-g · Accepted solution]

You can also leverage Regex Tool to Parse, (\d{7})(?=-firm paid).

 

[Neeta_Latwal]

Thankyou every, able to run the query. really helpful.

[FláviaB]

Hi @Neeta_Latwal. Don't forget to mark the answers that helped you as a solution; that way, you can help other users who may have the same question. 😉