How do I truncate or extract characters from a string? (OLD Syntax)

Created: 2014-08-01 09:33:09
Modified: 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

Share this article:
Knowledgebase

Directory
  1. Directify - Self Service

  2. Mimic - Replication

  3. UnitySync - Sync
Password
  1. emPass - Sync
Obsolete
  1. Profiler
  2. SimpleSync