Extracting string

Discussion created by shreedatye on Nov 29, 2018
Latest reply on Nov 29, 2018 by shreedatye

After connecting to a web service we receive data of variable length in this format which goes into a field. I would like to extract the string between the open bracket preceding <ID number> and the following close bracket. How do I go about it? xxxxx in the example are strings of variable length.


(xxxxxxxxxxxxx<abc>xxxxxxxxxxxxxxxxx);(xxxxxxx<ID number>xxxxxxxxxxx);(xxxxxxxxxxxxxxxxxxxxxx<def>xxxxxxxxxxxxxx)