How to extract digits after a character using rege…

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!

Read more here: Source link