Transforms

The Transforms elements can exist one time under the each source value and under the target value. It holds a number of transforms (see below) that are applied to either the source or the target value (before being written). A transform function could be to uppercase a string value before writing it to the target attribute value.

Values can be transformed before leaving the source and/or before being applied to the target attribute. This means that for each flow rule, you can have two sets of transforms.

Besides using the value of the specified source attribute, the different transform function may require additional configuration and settings. For information on how to configure the different transforms, see the individual transform functions below.

The following transforms are supported -

Binary handling

• Base64ToGUID
• Base64ToGUIDFormat
• SIDToString

Date handling

• FormatDate
• IsBeforeOrAfter
• ToFileTimeUTC

Bit handling

• IsBitNotSet
• IsBitSet
• SetBit

Boolean handling

• Not
• ConvertFromTrueFalse

Cross-reference handling

• LookupMVValue

Regular expressions

• RegexIsMatch
• RegexReplace
• RegexSelect

String handling

• LeftString
• PadLeft
• PadRight
• Replace
• ReplaceAfter
• ReplaceBefore
• RightString
• StringCase
• StringFormat
• Substring
• ToLower
• ToUpper
• Trim
• TrimEnd
• TrimStart
• Word

Multi-value handling

• MultiValueConcatenate
• MultiValueRemoveIfNotMatch
• MultiValueRemoveIfMatch
• MultiValueReplace

Missing a transform?

The idea is to expand the available transforms included to make this framework really comprehensive, so I would very much like to hear from you if you are missing a transform or have an idea for a generic transform that could simplify some flow rules.