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