...
| Function | Use |
|---|---|
| ? | Use this to evaluation the truth of an expression and return a value. The syntax is: condition? true expression : false expression. 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. The syntax is: expression1 ?? expression2. 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) | |
| Coalesce(expression1,expression2,...,expressionN) | |
| Escape(expression) | |
| FilterString(expression,allowedCharacters) | |
| GetDate(format='yyyyMMddhhmmss') | |
| If(condition,trueExpression,falseExpression) | |
| In(expression,string1,string2,...,stringN) | |
| IndexOf(expression,string) | |
| InTable("InTableName") | |
| Left(expression,string) | |
| Len(expression) | |
| 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 |
...