Using Reg ex to extract certain data

Question

I need to extract information within a longer string. The fields are different lengths with different number of characters before and after the information I need. But the data I need always follows TRN*1* and has an * at the end.  The bold below represents what I need it to return and the red represents the common characters that precede the information I need and follow the information I need. I know how to use regex when getting information out of a set of parentheses but cannot get this to work.  Also note I cannot just try to extract between the * because that returns "1"

:IA000696026735ZPNtdfdsffds18HCCLAIMPMT250929XXXXX7737TRN*1*747918*1236209407COMPANYNAME:ZPNtlElevInd1 IA38487547488XXXXX7737TRN*1*CJ115751355262168114*1391995276*0000UMCOMPANYNAME:UMREN

barrymoe · Accepted Answer

Hi @kimboyle

Do you know how to use the regex parse tool?
 
Here the regex expression I'm using...     *TRN\*1\*(.*)\*.*

And I have a screenshot of the configuration below. My guess is you were forgetting to escape out the special character of *... because the asterix is used as a regex descriptor of (0 or more) if you are trying to search for it specifically you need to precede it with a \.

I hope this helps!

caltang · Accepted Answer

Try this:

TRN\*1\*([^*]+)\*