- This topic has 2 replies, 2 voices, and was last updated 13 years, 9 months ago by
.
-
Topic
-
Has anyone successfully been able to get a “Copy” action (frl -> hl7) to default to @active_null if the Source value is not present? It’s not working for me and I would immediately attribute it to the fact that an frl field is never “empty” (in my case it’s all spaces); however, when I send it through XLT Test, my xlateInVals show an empty list, meaning this should trigger the default value, right?
Oh, and I’m currently on v 5.7.
-
Replies
-
-
Daniel,
In a flat record message/record no field is ever null (empty) – otherwise it could not be fixed length. Instead many times spaces are used to fille the field. Sometimes it is zeros if the field is numeric by definition.
So you would need something (tcl probably) to test to see if the field were all spaces or zeros or whatever (I have a Xltp type proc that does that let me know via email if you want that).
Then you can test in the Xlate using an IF Actikon to see if the result of the proc is true and if so copy =”” to the HL/7 field (or you could use your own proc and return the active null.
But are you sure you want to do this? The Active null in Hl/7 means the sending system wants the receiving system to ‘delete’ the field – make sure all spaces means delete.
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
-
- The forum ‘Cloverleaf’ is closed to new topics and replies.
