...
| Function | Use |
|---|---|
| ? | Use this to evaluation the truth of an expression and return a value. If the condition evaluates to "true," the true expression is returned, otherwise the false expression is returned. The specified condition must evaluate to a Boolean value. Example: MSH-3='ADM' ? 'HIS' : 'RIS' means that if the MSH-3 segment is ADM (true), the value returned will be 'RIS'; otherwise, the value returned will be 'RIS' |
| ?? | This function returns expression 2 if expression 1 is null; otherwise, it returns expression 1. Both expressions must evaluate to string values. Example: OBR-2 ?? OBR-3 ?? 'UNKNOWN' will return "unknown" if OBR-2 and OBR 3 evaluate to null. |
| AppendSegment(segmentName) | This function allows you to append a segment with the given segment name to the end of a message. Example: AppendSegment(OBR-2) will append the contents of the OBR-2 segment to the end of the message. |
| Coalesce(expression1,expression2,...,expressionN) | This function returns the first value from the list of expressions. One to N expressions can be included. Example: Coalesce(OBR-2,OBR-3,'UNKNOWN') will return UNKNOWN if OBR-2 and OBR-3 are empty. |
| Escape(expression) | This function encodes a string or expression with the HL7 Escape characters of the message. Example: Escape(MSH-2) will return "\S\\R\\E\\T\". |
| FilterString(expression,allowedCharacters) | This function returns a string containing only those characters specified in allowedCharaters. For example, the source system may provide a value in a field with extra characters; you can use this function to strip out only the characters in the string you are interested in. The expression must evaluate to a string; allowedCharacters specifies what will be passed through the filter. Example: FilterString(AA00BB12345,12345) will return the string "12345". |
| GetDate(format='yyyyMMddhhmmss') | This function will return the current date, as specified by the server machine, in the specified date format. The default format is yyyyMMddhhmmss (year, month day, hour, minute, second), but you can set whatever format you desire. Example: Using GetDate(format=yyyyMMdd) will return the date July 25, 2015 as "20140725". |
| If(condition,trueExpression,falseExpression) | This function evaluates a condition. If it returns True, the specified trueExpression will be used; otherwise, the falseExpression is used. This function is useful if, based on the contents of a particular segment, you want to write certain values to the message. The condition must evaluate to a Boolean value. Example: If(MSH-3='ADM','HIS','RIS') will return the value "HIS" if the MSH-3 segment contains "ADM"; otherwise, the function will return the value "RIS". |
| In(expression,string1,string2,...,stringN) | This function returns "true" if the expression evaluates to one or more values in the list. The expression must evaluate to a string. This is useful determining if an expression contains a valid string. Example: In(MSH-3='ADM','HIS','RIS') evaluates to true if the MSH-3 segment contains the string ADM, HIS, or RIS. |
| IndexOf(expression,string) | This function returns the one-based index of the string specified in the expression. Otherwise, it returns 0. Example: IndexOf('001234.5600') returns a value of 7. |
| InTable("InTableName") | This function uses the InTable with the specified name as a conditional expression. Example: InTable("Providers") will use the Providers table as a conditional expression. |
| Left(expression,string) | This function returns the string to the left of the specified match. Perhaps your source system always inserts a certain string in a segment, but you only want what immediately precedes the string in your transformed message. Use this function to extract that string. The expression must evaluate to a string and "string" is the characters to match. Example: Left('1234.56','.') will return the value "1234". |
| Len(expression) | This function returns the length (in characters) of the specified expression. The expression must evaluate to a string. Example: Len('123456') returns '6'. |
| LTrim(expression) | |
| LTrim(expression,string) | |
| Remove(expression,string1, string2,...,stringN) | |
| Replace(expression,string,string) | |
| Right(expression,string) | |
| RTrim(expression) | |
| RTrim(expression,string) | |
| Split(expression,charArray,index) | |
| SubString(expression,offset,length) | |
| Trim(expression) | |
| Trim(expression,string) | |
| UnEscape(expression |
...