Using Regex need to Extract a string between 2 different delimiters without multicolumns

sakshim

I have a problem, I want to extract a string between 2 different delimiters preferably with regex and without creating multiple columns .

For example, I have a substring which is like  '"ACTO": IMPID-452673";" at any place in the sentence.

I just need to extract IMPID-452673 (Kindly note the length of numbers can be more or less ). In every sentence, IMPID is followed by ";"  , 2nd delimiter. 1st Delimiter is  ""ACTO":")

binu_acs

@sakshim one way of doing this

Regex_17122024.yxmd