Multiply search criteria in SMAT

[Rentian Huang]

Greetings Cloverleafers!!!

In CL5.2 SMAT, I want to search msgs contain both A03 and PAT. I tried to put A03&&PAT and A03&PAT as Regular Expression in the “Include Those” text box, but none of them work.

Thanks for your help!

Sam  8)

Topic

[Max Drown (Infor)]

Try “A03.*PAT”

-- Max Drown (Infor)

[Beth Palmateer]

The only way I’ve ever been able to accomplish what you want is to take a two-step approach.  First, include all A03 records.  From that view, select “remove specified records”, then “NOT include those” and enter PAT.  Ignore the number of records selected, just press “yes” to add to the view.  You should end up with A03s that include PAT.

Beth

[Rentian Huang]

A03.*PAT works perfectly, Beth’s 2-step is good to know too, thanks all for your input!!!

Sam   8)

[Max Drown (Infor)]

Incidentally, from the command line, you can do some nifty searches using the scripts I posted here: https://usspvlclovertch2.infor.com/viewtopic.php?t=3097.

Ex. mgExtract file.msg | grep ‘A03’ | grep ‘PAT’ > test.hl7

-- Max Drown (Infor)

[Rentian Huang]

Thank you so much Max, for your contributions!!!

Sam  8)

[Author]

Replies