How do I truncate or extract characters from a string? (OLD Syntax)
Created: 2014-08-01 09:33:09Modified: 2017-05-01 10:37:26
Tags: Custom Mapping
This article is hidden.
This is for future reference. Refer to kb 258. The previous functionality didn’t work quite right in UnitySync v2. It’s not a priority, so I’m removing the syntax from the KB. We can reinsert it if this gets fixed in the future.
The same logic may be used on the ^SourceAttribute^ portion of the mapping for a similar result: i.e. Using the first example from above: extension-attribute-1=^sn#4,0^
Further, attributes may be “built” from multiple source fields or with a combination of fixed values. For example, take the first letter of given name, period, full last name, dash, last 4 digits of phone number would look like:
extension-attribute-1024#=^givenname#1^.^sn^-^telephonenumber#4,-4^
result: E.Richardson-7890
Another way to pull trailing digits is to use substr sub routine: extension-attribute-1024#=^givenname#1^.^sn^ -&substr(“^telephonenumber^”,-4,4)&
Same result: E.Richardson-7890