Parsing Message for Multiple ZAD segments and removing them based on what information is present #6006

dombarone · 2023-12-01T17:49:34Z

dombarone
Dec 1, 2023

Good afternoon,

I'm looking to have a transformer in Mirth remove a ZAD segment if ZAD.1 == 0 and the rest of the segments are blank. I can get this to work when there is only one FT1 segment, but we send out charges with multiple FT1 segments and the logic doesn't work when there are multiple.

Sample Message
MSH|^&|RCx|10020308|Ntierprise|Michigan Institute Of Urology PC|20231201095330||DFT^P03|04ce5874-429e-4fd7-813c-5421b7679223|P|2.7|||AL
EVN|P03|20231201095330334
PID|1|6326310|6326310||Test^Milo||20101110|M|||Home lane ^^Gretna^LA^70056||||||||567-89-0432|||||||||||N
PV1|1|O|UCBR|||||Rubin||||||||||||||||||||||||||||||||||||||||||11014907
FT1|1|48965089-d14c-40f5-adf7-75b7196dde80|1025|20231121^||CG|99213|||1|||UC|||UCBR|||V80.1^^I10W56.51^^I10|JA01Anem|JA01Anem||||99213|||||||
ZVA|48965089-d14c-40f5-adf7-75b7196dde80
ZDS|||||||
ZAD|0|||||||||||||||||||||||||||||||||||||||
FT1|2|858a6556-074c-4e54-90ca-9068fb115bcc|1025|20231121^||CG|80050|||1|||UC|||UCBR|||V80.1^^I10~W56.51^^I10|JA01Anem|JA01Anem||||80050|||||||
ZVA|858a6556-074c-4e54-90ca-9068fb115bcc
ZDS|||||||
ZAD|0|||||||||||||||||||||||||||||||||||||||

Current iteration of transformer

var count=0;
    for each (segment in msg.children() ){
        if(segment.name() == "ZAD"){
                if ((msg['ZAD'][count]['ZAD.1']['ZAD.1.1'].toString() == "0") 
                && (msg['ZAD'][count]['ZAD.2']['ZAD.2.1'].toString() == "") 
                && (msg['ZAD'][count]['ZAD.3']['ZAD.3.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.4']['ZAD.4.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.5']['ZAD.5.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.6']['ZAD.6.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.7']['ZAD.7.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.8']['ZAD.8.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.9']['ZAD.9.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.10']['ZAD.10.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.11']['ZAD.11.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.12']['ZAD.12.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.13']['ZAD.13.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.14']['ZAD.14.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.15']['ZAD.15.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.16']['ZAD.16.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.17']['ZAD.17.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.18']['ZAD.18.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.19']['ZAD.19.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.20']['ZAD.20.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.21']['ZAD.21.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.22']['ZAD.22.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.23']['ZAD.23.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.24']['ZAD.24.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.25']['ZAD.25.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.26']['ZAD.26.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.27']['ZAD.27.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.28']['ZAD.28.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.29']['ZAD.29.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.30']['ZAD.30.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.31']['ZAD.31.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.32']['ZAD.32.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.33']['ZAD.33.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.34']['ZAD.34.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.35']['ZAD.35.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.36']['ZAD.36.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.37']['ZAD.37.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.38']['ZAD.38.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.39']['ZAD.39.1'].toString() == "")
                && (msg['ZAD'][count]['ZAD.40']['ZAD.40.1'].toString() == "")){
                                delete msg['ZAD'][count];
                
                }
                count++;
        }
    }

I'm getting the following error when trying to transform the sample message above

Transformer error
ERROR MESSAGE: Error evaluating transformer
com.mirth.connect.server.MirthJavascriptTransformerException:
CHANNEL: MIU DFT Out
CONNECTOR: sourceConnector
SCRIPT SOURCE: TRANSFORMER
SOURCE CODE:
102:
103:
104: var count=0;
105: for each (segment in msg.children() ){
106: if(segment.name() == "FT1"){
107: if ((msg['ZAD'][count]['ZAD.1']['ZAD.1.1'].toString() == "0")
108: && (msg['ZAD'][count]['ZAD.2']['ZAD.2.1'].toString() == "")
109: && (msg['ZAD'][count]['ZAD.3']['ZAD.3.1'].toString() == "")
110: && (msg['ZAD'][count]['ZAD.4']['ZAD.4.1'].toString() == "")
111: && (msg['ZAD'][count]['ZAD.5']['ZAD.5.1'].toString() == "")
LINE NUMBER: 107
DETAILS: TypeError: Cannot read property "ZAD.1" from undefined
at 85fad354-4983-40d7-a59e-86f9356537b1_JavaScript_Filter_Transformer_0:107 (doTransform)
at 85fad354-4983-40d7-a59e-86f9356537b1_JavaScript_Filter_Transformer_0:174 (doScript)
at 85fad354-4983-40d7-a59e-86f9356537b1_JavaScript_Filter_Transformer_0:176
at com.mirth.connect.server.transformers.JavaScriptFilterTransformer$FilterTransformerTask.doCall(JavaScriptFilterTransformer.java:235)
at com.mirth.connect.server.transformers.JavaScriptFilterTransformer$FilterTransformerTask.doCall(JavaScriptFilterTransformer.java:187)
at com.mirth.connect.server.util.javascript.JavaScriptTask.call(JavaScriptTask.java:114)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)

Does anyone have any thoughts or suggestions? I'm new to Mirth and I feel like the solution is sitting right in front of my nose.

Thanks,
Dom

Answered by pacmano1

Dec 1, 2023

you might need:

var modifiedMessageString = hl7MessageString.replace(/^ZAD\|0(\|*)+\r?$/gm, '').replace(/\r\r/gm, '\r')

I probably was pasting new lines for line ends, they should be carriage returns as per spec.

View full answer

pacmano1 · 2023-12-01T17:52:19Z

pacmano1
Dec 1, 2023
Collaborator

@dombarone please format your code and use code blocks. Read https://docs.github.com/en/get-started/writing-on-github/getting-started-with-writing-and-formatting-on-github/basic-writing-and-formatting-syntax

0 replies

pacmano1 · 2023-12-01T18:28:14Z

pacmano1
Dec 1, 2023
Collaborator

Import @tonygermano xfilter code template from: https://github.com/nextgenhealthcare/connect-examples/tree/master/Code%20Templates/Filter%20XMLLists and make sure in channel dependencies it is avaiable to your channel.

Then:

function keepZadSegment(zadSegment) {
    // Check fields after ZAD|0|
    for (var i = 2; i < zadSegment.children().length(); i++) {
        if (zadSegment['ZAD.' + i].toString().trim() !== '') {
            return true; // Keep this segment as it has non-empty fields
        }
    }
    return false; // Remove this segment as all fields are empty
}

var filteredZads = xFilter(msg.ZAD, keepZadSegment, 0, Number.MAX_VALUE, false);

// Assign the filtered ZAD segments back to msg.ZAD
msg.ZAD = filteredZads;

Before:

MSH|^~\&|||||19070618072145||ORU^R01|MSG0000000001|P|2.5|||ER
PID|1||1640666107||LUCAS^SANDRA^B|RICE^AUDREY^H||F|BRAME^BEVERLY^H
PV1|1|I
OBR|1
TQ1|1
OBX|1||||eirmod tempor invidunt ut labore et dolore||||||P~P
SPM|1|||||||||||||xxTESTxx||||19100213140054
ZAD|0||||
ZAD|0|||1|

After

MSH|^~\&|||||19070618072145||ORU^R01|MSG0000000001|P|2.5|||ER
PID|1||1640666107||LUCAS^SANDRA^B|RICE^AUDREY^H||F|BRAME^BEVERLY^H
PV1|1|I
OBR|1
TQ1|1
OBX|1||||eirmod tempor invidunt ut labore et dolore||||||P~P
SPM|1|||||||||||||xxTESTxx||||19100213140054
ZAD|0|||1|

12 replies

dombarone Dec 1, 2023
Author

var hl7MessageString = message
var modifiedMessageString = hl7MessageString.replace(/^ZAD\|0(\|*)+\r?$/gm, '').replace(/\n\n/gm, '\n')
return modifiedMessageString;

pacmano1 Dec 1, 2023
Collaborator

need to see the line endings, right click in the messge viewer and "Show Line Ending"

dombarone Dec 1, 2023
Author

pacmano1 Dec 1, 2023
Collaborator

you might need:

var modifiedMessageString = hl7MessageString.replace(/^ZAD\|0(\|*)+\r?$/gm, '').replace(/\r\r/gm, '\r')

I probably was pasting new lines for line ends, they should be carriage returns as per spec.

Answer selected by dombarone

dombarone Dec 1, 2023
Author

Thank you!!! This is it. Have a great weekend.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Parsing Message for Multiple ZAD segments and removing them based on what information is present #6006

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 2 comments 12 replies

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

Parsing Message for Multiple ZAD segments and removing them based on what information is present #6006

dombarone Dec 1, 2023

Replies: 2 comments · 12 replies

pacmano1 Dec 1, 2023 Collaborator

pacmano1 Dec 1, 2023 Collaborator

dombarone Dec 1, 2023 Author

pacmano1 Dec 1, 2023 Collaborator

dombarone Dec 1, 2023 Author

pacmano1 Dec 1, 2023 Collaborator

dombarone Dec 1, 2023 Author

dombarone
Dec 1, 2023

Replies: 2 comments 12 replies

pacmano1
Dec 1, 2023
Collaborator

pacmano1
Dec 1, 2023
Collaborator

dombarone Dec 1, 2023
Author

pacmano1 Dec 1, 2023
Collaborator

dombarone Dec 1, 2023
Author

pacmano1 Dec 1, 2023
Collaborator

dombarone Dec 1, 2023
Author