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

What tool?

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

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

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

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

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

Also performed with HL7 and Advanced.

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!  😀