regexp to be used in SMAT tool (text files) for NO ORC

[Bob Schmid]

Want to search SMATS for ORU’s that do NOT contain an ORC

have tried some “not conditions” and still haven’t found what im looking for  😕

Topic

[Keith McLeod]

What tool?

I would add all ORU^R01 to your view and then remove those containing rORC. Let me know if this helps.

[Charlie Bursell]

In Tcl, the following expression using negative look-ahead will work.  I have not tried it with SMAT

{ORU^R01(?!(.*rORC.*))}

[Bob Schmid]

Both good ideas.

I haven’t tried the regexp yet…but will shortly

Thanks fellas! for taking the time!

Bob

Your reward is great (in heaven!)

😀

[Keith McLeod]

On the SMATDB side of the equations it appears like charlies negative lookahead worked…..

ORU^R01(?!(.*rORC.*))

Also performed with HL7 and Advanced.

[Charlie Bursell]

You must remember that Tcl regexp default is that a newline is simply a character so the regexp would treat the whole file as as string.  I think SMAT reverses this and, by default, uses newline as end of a string.

So for the flat file you need to do something like:

regexp -line — {REGEXP}

The above would only match the first instance found so for all you would need something like:

set LIST [regexp -all -inline -line — {REGEXP}]

Of course this assumes your flat file is saved as newline delimited.  It would not work against a .msg file of len10 file.  That would really get hairy!  😀

[Author]

Replies