regexp in SMAT 5.8.5

[Don Brown]

We are on QDX 5.8.5. I have a large SMAT file and am looking for a regexp to pull in only messages that have SD as the State in the PID segment. Does anyone have a way to do this without pulling the State SD from other segments? I am open to other suggestions as well.

Don Brown

Sanford Health

Interface Analyst

605-328-7377

Don.Brown@sanfordhealth.org

Topic

[Keith McLeod]

Give this a whirl.  I am guessing PID:11.3 where 3 is the 4th component in a zero based index notation.  The r helps confirm that you are in the PID segment as opposed to a random occurence of PID.

rPID(?:[^|]*|){11}(?:[^^]*^){3}(SD)

[Don Brown]

Thanks Keith – Your regexp worked great to find only messages with SD in PID:11.3.

rPID(?:[^|]*|){11}(?:[^^]*^){3}(SD)

Don Brown

Sanford Health

[Author]

Replies