How can i convert a csv with multiple rows into multiple HL7 message for each row?

Question

Here is my source csv file: "Patient ID","Patient First Name","Patient Last Name","Patient DOB","Patient Gender","Patient Address Line1","Patient Address Line2","Patient City","Patient State","Patient Zip Code","Patient Home Phone","Patient Email Address","Primary Insurance Policy Company Name","Primary Insurance Policy Number","Primary Insurance Policy Group Number" "1","test","abc","19800819","F","flat 1 road no A","xyz colony","Hyderabad","Telangana","500097","987-889-5858","test.abc@cognizant.com","","","" "2","test","def","19800819","F","flat 1 road no A","xyz colony","Hyderabad","Telangana","500097","987-889-5858","test.abc@cognizant.com","","","" "3","test","ghi","19800819","F","flat 1 road no A","xyz colony","Hyderabad","Telangana","500097","987-889-5858","test.abc@cognizant.com","","",""

Answer 1

Please see the following KB article, which addresses a similar situation:

https://www.qvera.com/kb/index.php/610/how-to-import-a-csv-and-generate-multiple-hl7-messages?show=610#q610