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!