Pulling text from MDM and creating CSV file
Hi,
I've setup an operation that pulls text from an MDM message and uses it to generate a csv file. I'm having issues as our vendor is sending the file with a carriage return (as shown below) to signify the next line but Healthshare is recognising this as a new segment which causes an error.
MSH|^~\&|TIE|PATHPOINT|LNWH|PAS|20200407061001||MDM^T02|PATHPOINT2020040706100154094|P|2.4|||NE|AL|GBR|UTF-8|EN|
EVN||20200407061001|
PID|1|123456789^PAS^PAS|02572543^^^INT^XR~6111111111^01^^NHS^NH~4111111^^^NWL^NWL||TEST^PATIENT||19010101000000|M|
PV1|1|E||||||||190^ANAES|
TXA||TS||20200407061001|||||PATHPOINT|||1586236201|
OBX|1|ED|||^^Csv^TXT^NHS number,Hospital number,Name,
I'm wondering if there is a way for the text to include a carriage return without causing this error?
Thanks,
Martin
Have a look at this document on HL7 escape sequences.
Can you please check the Framing setting on the inbound Business Service. You might try setting it to Flexible or other option and see if it works for you.