Parsing CSV Files
Verified
Added by iNTERFACEWARE
A project demonstrating how parse CSV files.
Description
A project demonstrating how parse CSV files.
Attachments
Usage Details
1. Create a channel with a To Translator destination
2. Import the attached project zip file to in the Destination Translator
More Information
Added by iNTERFACEWARE
How to prevent escaping of special characters like "&" in an HL7 message
Added by quickbook
You should QuickBooks Tool Hub Download for numerous reasons. Pick a Program Issue If the program crashes or stops operating, performs poorly, is d
Added by iNTERFACEWARE
This function formats phone numbers nicely with the area code in brackets.
Added by iNTERFACEWARE
How to format an HL7 message without the trailing "|" at the end of each line
Added by iNTERFACEWARE
Use smtp.send() to send an email from your Lua code.
Added by iNTERFACEWARE
Basic example of merging data into a SQLite database (code is "plug and play" as the DB will be created if it does not exist)
Added by iNTERFACEWARE
Simple functions to strip or add leading zeros
Added by iNTERFACEWARE
Demonstrates the best way to set a XML node to a space character, by using setText(' ') from the xml.lua module
Added by iNTERFACEWARE
How to use transactions and conn:begin{}, conn:execute{} and conn:commit{} to insert data into a database in a specific order.
Added by iNTERFACEWARE
Demonstrates the best way to read an empty XML TEXT element, by using the text(' ') function from the xml.lua module
Added by iNTERFACEWARE
How to process a batch of HL7 messages by removing the batch header and splitting it into separate messages.
Added by iNTERFACEWARE
How to map all or part of an HL7 message (similar principles apply to other message types)
Added by iNTERFACEWARE
Retry an ODBC query to a MySQL DB when an error occurs, can be adapted for retrying LLP etc.
Added by iNTERFACEWARE
How to transform part of an HL7 message (similar principles apply to other message types)
Added by iNTERFACEWARE
Format specified HL7 message fields in a tab delimited string and push the string to the queue for further processing
Added by iNTERFACEWARE
How to filter out unwanted HL7 messages (similar principles apply to other message types)
Added by iNTERFACEWARE
How to normalize X12 delimiters for processing in Iguana scripts, they can be reverted after processing if needed
Added by iNTERFACEWARE
How to insert data from an HL7 message into a database (similar principles apply to other message types)