CONCAT Function

Concatenating multiple source string values into one.

Purpose

For concatenating multiple source strings into one. A source string can be a static string value or a reference to a data element.

Format

CONCAT (source-value-1, source-value-2, … , source-value-N)

Example

The following config entry in am HL7DataTransformer handler appends a prefix and a suffix to the MSH-3 field of an HL7 record.

<Parameter>
  <!-- CONCAT Example -->
  <Name>transformation-rule</Name>
  <Value>$MSH-3=>CONCAT("prefix-", $MSH-3, "-suffix")</Value>
</Parameter>
InputOutcome
MSH|^~\&|Foldda||MSH|^~\&|prefix-Foldda-suffix||

Related

Nil.