Using Regex need to Extract a string between 2 dif…

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”:”)

Read more here: Source link