filter out messages with compound IF statement in XLATE

[Duy Nguyen]

I want to filter out messages that contain the red portion, which should be SCH-11.1 and SCH-11.2:

SCH|||||||- ||0|MIN|^0^MINUTES

Would you guys/gals please review my XLATE statement to see if it’s legitimate as far as syntax goes?  Do I need to add brackets/parentheses anywhere?  Thanks!

>IF 0(0).SCH.00884(0).[1]  == 0 &&  0(0).SCH.00884(0).[2]  eq =MINUTES

>SUPPRESS

Topic

[Nora Katz]

Did you try testing it?  Did you get errors?

[garry r fisher]

Hi Duy,

If possible I would filter out these transaction before you get to the XLATE. The xlate is the bottleneck is Cloverleaf and anything you can do to improve throughput by filtering out unwanted messages before your xlate will be beneficial.

I’d use a TPS rather than an xlate.

Regards

Garry

[Duy Nguyen]

I’m having no luck with figuring out how to construct a legal compound IF within the XLATE and also running it through the TESTING TOOL w/o problems.

I will go ahead and code a TPS…but:

Can you verify that I’m checking for the correct field components, if what I’m wanting to filter on is the portion in RED.  Thank you.

[Vincent Tran]

maybe the 0 is a string

try eq =0

I was reading up on the Suppress command. Does it do what you want? I was reading the documentation and it said that it sends the message? So it was a bit confusing.

[Duy Nguyen]

It was set to string but still experiencing problems.  Does anyone know how to make a compound IF statement work?

[Nora Katz]

Try assigning the zero to a variable first, then use the variable in the if statement.

Copy      =0 –>  @zero

IF 0(0).SCH.00884(0).[1]  == @zero &&  0(0).SCH.00884(0).[2]  eq =MINUTES

[John Mercogliano]

Try this

IF 0(0).SCH.00884(0).[1]  == =0 &&  0(0).SCH.00884(0).[2]  eq =MINUTES

Even though you are doing numeric comparison you still have to use the extra equal sign with the 0.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Duy Nguyen]

Nora Katz wrote:

Try assigning the zero to a variable first, then use the variable in the if statement.

Copy

[Nora Katz]

do you need single or double quotes or curly braces around MINUTES?

[Duy Nguyen]

Here is the test data I’m using:

---

MSH|^~&|FLOWCAST|FLOWCAST|||200705300722||SIU^S15|60780_618_SC8|P|2.3|||AL

SCH|||||||- ||0|MIN|^0^MINUTES

PID|1||1055358||CHRISTIAN^SHERRIL^D||19310928|M||4|2891 TWIN ACRES DRIVE^^NORMAN^OK^73071||(405)329-1892|(405)325-2054||2||||||||||||||Y

PV1|1|O|-

NTE|1||NO COMMENT

AIP|1

---

XLATE file and testing tool results file are attached

Thanks for your help everyone…I’m still tackling what should be an easy issue.

[/img]

[Nora Katz]

I only see MSH, I don’t see the rest of the message.  Perhaps you need to select EOF terminated instead of New Line Terminated?

[Duy Nguyen]

I tested both ways…same result.

[Michael Hertel]

Your data file contains at the end of each segment.

Please fix your data so the segments only end with

then try your testing tool again.

Also, your output contains “Error occurred at: ‘]

[Duy Nguyen]

Michael Hertel wrote:

Your data file contains at the end of each segment.

Please fix your data so the segments only end with

then try your testing tool again.

Also, your output contains “Error occurred at: ‘]

[Michael Hertel]

Can you post the contents of the file Flowcast_SIU_EMR.xlt here instead of the picture?

Also, did you make sure the file only contained carrage returns in the message?

[Nora Katz]

Duy,

Michael’s other comment also needs looking into.  “Your data file contains at the end of each segment.”

In your testing tool, you should see all the segments of your message (MSH, SCH, PV1, NTE, AIP) not just the MSH segment.

You should only have a after each segment.  You file appears to have a carriage return and a line feed character after each segment.

Nora

[Duy Nguyen]

Everything has worked itself out now.  I appreciate all the tips/suggestions!

[Author]

Replies