Question
· Apr 7, 2020

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

Discussion (2)2
Log in or sign up to continue