Forum Discussion
Bobby1105
Nov 15, 2021Copper Contributor
CSV Import. Separation Character 'list'
In the cvs import method you may specify what character to use as a separator. It is very useful for importing HL7 messages into Excel as CSV files. However, Excel unlike 123 (a now long gone sp...
SergeiBaklan
Nov 15, 2021Diamond Contributor
I'm not familiar with HL7. However, as a comment. Perhaps if you use it on regular basis better to use some third-party tools like HL7 Soup - HL7 Interface Engine, Editor and Analysis Software , maybe open source exists.
Power BI Desktop has FHIR server connector Power Query connector for FHIR | Microsoft Docs.
Above is first in mind, I believe other options exist. IMHO, convert HL7 to CSV with manual transformations is not very productive, the same as to do that for XML.