Split strings using a delimiter
Verified
Added by iNTERFACEWARE
Use the string.split() function to split a string into parts separated by a specified delimiter
Source Code
-- split the message into individual lines "\r" separator
local r = msg:split('\\r')
trace(r)
-- allow for the \n added because we split the msg declaration over multiple lines (above)
local r = msg:split('\\r\n')
trace(r)
-- split the message into fields "|" separator
local r = msg:split('|')
trace(r)
Description
Use the string.split() function to split a string into parts separated by a specified delimiter
Usage Details
Use string.split() to break a string into multiple parts using a specified separator. We used an HL7 message as an example. When we declared the string the editor added newlines (\n) so our first split contained \n at the start of the split strings (which we did not want). Our second split allows for this by specifying the newline as part of the separator.
How to use the snippet:
- Paste the split code into your script
Note: You may also be interested in the splitText() function which can be use to split a long reports into chunks of a specified length.
Added by iNTERFACEWARE
Code to connect to commonly used databases (connecting to other databases is very similar).
Added by iNTERFACEWARE
How to parse an HL7 message and create an HL7 output message
Added by iNTERFACEWARE
Use pcall() to trap errors by calling a function in protected mode (use to prevent a channel from stopping on "innocent" errors).
Added by iNTERFACEWARE
Use the error() function to raise an error and write it to the logs
Added by iNTERFACEWARE
How to create Error, Warning, Informational, and Debug log entries
Added by iNTERFACEWARE
How to open and read a file from disk, either one line at a time, or read the whole file at once
Added by iNTERFACEWARE
How to convert numbers and node trees to a to string representation, and how to convert a numeric strings to numbers
Added by iNTERFACEWARE
How to parse an XML message using xml.parse()
Added by iNTERFACEWARE
Using date and time functions with some formatting examples
Added by iNTERFACEWARE
Execute programs and batch files, you can also load results from a directory listing etc.
Added by iNTERFACEWARE
Convert characters to/from numeric codes, the codes will vary depending on the code page settings
Added by iNTERFACEWARE
Find the position of the first instance of a string (pattern) within a string, returns the start and end indices
Added by iNTERFACEWARE
Use string.gsub() to find and replace one or more instances of text within a string
Added by iNTERFACEWARE
Using # or string.len() to find the length of a string, the result is the same
Added by iNTERFACEWARE
Convert a string to upper case with string.upper(), or lower case with string.lower()
Added by iNTERFACEWARE
Use string.sub() to return part of a string, by specifying the start and end positions
Added by iNTERFACEWARE
Use conn:query() to select data from a table in a database
Added by iNTERFACEWARE
Use conn:execute() to insert data into a database table
Added by iNTERFACEWARE
Use conn:execute() to update a database table
Added by iNTERFACEWARE
Use conn:merge{} to merge data into a database