How to extract digits after a character using regex in formula tool

[dizy_11]

Hi all,

Hope you all are doing great!

I'm stuck with regex. I have attached a sample input data. What i basically need to do is in whatever string character "(" is present, i need to extract all the digits just after the character "," from the string else will print digit 0 in output if character "(" is not present. And there could be multiple digit also present after the character ",".

I have attached the sample input and the output which i want. 

Please help me how can i do this in formula tool by applying regex_replace() function.

Thanks for your help in advance!

[Sebastiaandb]

Hi @dizy_11 ,

Here you go!

Let me know if that works for you :-).

Greetings,

Seb

[PhilipMannering]

You can use the Regex Tool set to parse with expression,

,(\d+)

And then use the impute tool to fill in the zeros. Solution attached.