Searching for a specific group in the OBXs

[Kevin Crist]

i have to search through the OBXs for the phrase “RADIOLOGY CONSULTATION” which is usually in the 3rd OBX.5 field as part of a header recieved from the sending system. I need to do some work based on if that is true or not and not sure how the best way to do it.

I have an example of the screen shot, there is about 29 -30 spaces in the OBX until the phrase, is there a way to code for that?

This Xlate is using bulkcopy.

Topic

[Daniel Lee]

I think I’d probably copy that field to a variable first striping all the spaces out of it on the copy.  Then in your if statement check to see if the variable eq “RADIOLOGYCONSULTATION”

[Kevin Crist]

i think my problem is that is scanning every OBX, so even if it is in the 3rd OBX it keeps going and overwriting until then until it is basically never equal to the variable. Is there some way to break it like in tcl?

[Jim Kosloskey]

Use one iteration to discover if the text exists (the CT in the Xlate IF might work saving Tcl), set a temp variable switch indicating found or not found (y and n or 0 and 1 whatever you prefer).

Iterate again checking the temp variable set in the first iterate and do your work depending on that – don’t forget to reset the environment variable when you no longer need it set.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Author]

Replies