Hi Cringer,
this is the file
MSH|^~\&|ISH|ISH^BVH|CLOVERLEAF|CLOVERLEAF|20150302105115|NP11I0|ADT^A01|00338104|P|2.3|||AL|NE
EVN|A01|20150302105115|||IBMSWX|NP11I0
PID|||S8841454^C^M11^MRN||CHIA XIN LING^^^^Mr||19881027|M||CN|JURONG WEST STREET 64^^669C^^^^^^643669^SG||||EN|M||||P^P||||||1||SG||N
NK1||CHIA XIN LING||JURONG WEST STREET 64^^669C^^^^^^643669^SG
PV1||I|W73^^^SG|1|||11438C^COLIN PHIPPS DIONG^^^^AC|||DIM|||^Y|1||N|84333D^CHIONG YI^^^^HO||6715100608A^A^M10|B2+~4|||||||||N|||||||||||||||20150302105012|||||||Y
PV2||CCUB2+|||||||||||20|||||||||||||||20150302105012
if you notice the MSH,EVN,PID,NK1,PV1,PV2 they were arrange in a row, try to copy this file in a notepad it's a single line only.
so i will import this whole record and place it in a variable the value that was capture was this only
MSH|^~\&|ISH|ISH^BVH|CLOVERLEAF|CLOVERLEAF|20150302105115|NP11I0|ADT^A01|00338104|P|2.3|||AL|NE
i trying to achieve was if i can remove the Carriage Return/Line Feed and capture all the data in single variable