Previous Topic: Section SyntaxNext Topic: Object Storage

Platform Deployment Guide › Account Import › Modify LDAP Values with Conversion Expressions › Conversion Expression Variables

Conversion Expression Variables

<search_text>

Is the actual text you want to detect within the LDAP attribute value. For example:

smtp:

You use the search text to locate the start of the 'extracted text’.

<extracted_text>

Is the text extracted from the LDAP attribute value and incorporated (after modification, if necessary) into the resulting CA DataMinder attribute value.

The extracted text is the text immediately after the search text in an LDAP attribute value, for example, srimmel@unipraxis.com.

You must enclose this text in curly brackets { }.

You can use variables to represent any single component that you want to extract. The supported <extracted_text> variables and wildcards are:

%word%

Matches a whole word (that is, an unbroken sequence of alphanumeric characters).

%digits%

Matches a sequence of digits.

%alpha%

Matches a sequence of letters.

?

Matches any single character.

%a% or %A%

Matches any single letter.

%d% or %D%

Matches any single digit.

%l% or %L%

Matches any single letter or digit, but not others such as / or = characters.

%until(x)%

Matches all extracted text up to (but not including) any character x specified in the brackets. For example:

%until(/)% matches all text until a / is detected.

%until(pq)% matches all extracted text until p or q is detected.

Note: If the character is not detected, the parameter matches all text up to the end of the LDAP attribute value.

(x)%untilEnd%

Matches all extracted text starting from (and including) any character x specified in the brackets, up to the end of the input string. For example:

"smtp:{%untilEnd%}"

Matches the entire input string if it begins with an ‘smtp:’ prefix, but removes this prefix from the extracted text. The expression only extracts text within the curly brackets.

%untilstr(str)%

Matches all extracted text up to (but not including) any string specified in the brackets. For example:

%untilstr(/ou,/cn)%

Matches all extracted text until /ou or /cn is detected.

Note: If the string is not detected, the parameter matches all text up to the end of the LDAP attribute value.

prepend=<term>

Prepends, or precedes, the specified <term> in front of the output string.

Note: You do not need to enclose the prepended string in quotes. For example:

prepend=UK.
append=<term>

Appends the specified <term> to the output string.

Note: You do not need to enclose the appended string in quotes.

repeat=<N>

(Optional argument) Takes the Nth matching result. For example: 

repeat=0

Matches the first matching result.

repeat=1

Matches the second matching result.

repeat=last

Matches the last matching result.

For example, to derive a CA DataMinder user name from: 

/O=UNIPRAXIS/OU=ADMIN GROUP/CN=RECIPIENTS/CN=SRIMMEL

Use this expression:

["/O={%word%}"]\\["/CN={%word%}",repeat=last]

This yields the CA DataMinder user 'unipraxis\srimmel'.

subsection=<pos_A>:<pos_B>

(Optional argument) Specifies a subsection of the matching text, from character position <pos_A> up to, but not including, character position <pos_B>.

For example:

subsection=0:1

Specifies a subsection that comprises only the first character of the matching word.

subsection=1:3

Specifies a subsection that comprises the second, third, and fourth characters of the word.

subsection=0:-2

Specifies a subsection that comprises the final three characters of the word.

substitute=<term>:<new_term>

(Optional argument) Substitutes text in the 'extracted text' with your own string. <term> is the text that you want to replace. <new_term> is your own text that you want to substitute into the CA DataMinder attribute value.

Note: <term> can only match whole words. For example, if the extracted text is UNIPRAXIS, you cannot substitute "UNI" for "MULTI".

mandatory

Specifies that if no matching 'search text' is found, then Account Import quits trying to modify the imported attribute value. Unless substitute text is specified, a null string is imported into the CA DataMinder attribute. That is, the attribute for that user has no value.

Note: 'mandatory' overrides the default declaration.

default=<term>

Specifies that if no matching 'search text' is found, then a default text string is returned as the 'extracted text'. If this happens, <term> is the default text string For example: unknown user.

Note: You do not need to enclose the default string in quotes.

if"Zoom"[<then>]else[<else>]

Specifies an "if...then...else" clause. If the Zoom string is found, the <then> expression is performed. If the Zoom string is not found, the <else> expression is performed. For example:

if"Sales.Unipraxis"[prepend=UK.] else["{@%untilEnd%}"]

Changes ‘sales.unipraxis’ to ‘UK.Sales.Unipraxis’, or if ‘Sales.unipraxis’ is not detected, then the parameter matches all text from ‘@’ to the end of the LDAP attribute value. (The prepend variable is described above.)

pp"Zoom":"<replace>"

Performs a search and replace operation on the strings within the quotes. That is, the first string is replaced with the second. For example:

pp",":"" removes all commas

pp",o":"/o" replaces ,o with /o

The supported variables and wildcards are the same as those supported by the <extracted_text> variable.

You can also specify a section to extract and then use that extracted text in the replace expression. For example:

pp",{%a%}=":"/%1%="

Converts strings such as ,o= to /o=. This example works with any letter. In each case, the single letter found by the search operation is re-used in the replace expression, where %1% is the extracted string from the search text.

Likewise, this example prepends (or precedes) the search string with a forward slash:

pp"{?%untilEnd%}":"/%1%"