Article Randy Pallotta · Jul 27, 2016 2m read "dynamic" headers and trailers for ensemble record maps Hello, #Ensemble 0 0 0 461
Article Randy Pallotta · Jun 7, 2016 1m read Using Ensemble SQL Operations for Selects, Updates, Inserts, and Stored Procedure calls Hello,We are sometimes asked for examples of how to do 3rd party SQL database selects/updates/inserts/stored procedures from an Ensemble SQL Business Operation.In the attached file there are 4 sample Ensemble Operations that demonstrate four different types of transactions with an external SQL DB: #Ensemble #Business Operation #SQL 5 3 0 1.8K
Article Randy Pallotta · May 27, 2016 3m read Removing all trailing delimiters for fields and segments in HL7 messages Two fairly common requests we receive from HL7 customers are (1) how to remove all trailing delimiters for fields and segments in HL7 messages and (2) how to "find and replace" for an entire HL7 message (as opposed to one segment/field at a time). The code sample below shows a custom function that solves for item 1 and by extension item 2 above. In other words the same approach can be used for finding/replacing any sequence of chars in an entire HL7 message, with some tweaks to the custom function. #Code Snippet #DTL #HL7 #Ensemble 7 6 0 3.4K