
Read the HL7 field separator from MSH
MSH|^~\&|LAB|SITEA → |
3 free Excel templates to keep HL7 interface fields intact. Pick the one that matches your list, download it and paste your data in. No sign-up, no macros.
3 templates

MSH|^~\&|LAB|SITEA → |

A40 + MR4012 + MR3807 → Surviving=MR4012; prior=MR3807

1001 LAB, 1001 RIS → Placer: 1001 [LAB]; filler: 1001 [RIS]