Extract Number in () from String

[raunak_1990]

Hello,

I have a scenario below wherein I need to extract the number from a string:

([Customer_Name (00001)
([Customer_Name (0000190)
([Customer_Name (0000190794)

The number does not have a fixed length, but I need to extract only the numeric value.

Could you help me with this scenario?

Thanks in advance.

[grossal · Accepted solution]

Hi @raunak_1990,

you can do this using a Regex-Tool and a Formula (to convert it to an actual number).

Output:

Workflow attached. Let me know what you think.

Best

Alex

[raunak_1990]

Thanks for the solution @grossal.

Works like a charm!