Field name
|
Format
|
First name
|
user.firstName
|
Last name
|
user.lastName
|
Primary email address
|
user.email
|
Full name
|
user.displayName
|
Any custom fields' information
|
user.<custom field>
Example: For a field named
Vehicle Number
, the format would be user.Vehicle Number.
|
String methods
|
Expression format
|
Description
|
Example
|
Append
|
String.append(<string>,<string_to_be_appended>)
|
Adds <string_to_be_appended> to the end of the <string>.
|
String.append(user.firstName,user.Employee ID)
The value in the user's "Employee ID" field will be appended with the user's first name. If a user's first name is "Amelia" and employee ID is "7469," then the value will be "Amelia7469".
|
Index Of
|
String.indexOf(<string>,<character>)
|
Returns the position of the first instance of the given character in the <string>.
|
String. indexOf(user.firstName,"o")
Returns the position of the first instance of the character "o" within the user's first name. If a user's first name is "Johnson", then the position of the first occurrence of the character "o" will be returned, which is 2.
|
Replace
|
String.replace(<string>,<string_to_be_removed>,<string_to_be_placed>)
|
Replaces all occurrences of <string_to_be_removed> in the <string> with <string_to_be_placed>.
|
String.replace(user.firstName,"e","a")
All the occurrences of "e" will be replaced by "a". If a user's first name is "Ellen", then all occurrences of the character "e" in the name will be replaced by "a", giving "
Allan" as the output.
|
Replace First
|
String.replaceFirst(<string>,<string_to_be_removed>,<string_to_be_placed>)
|
Replaces the first occurrence of <string_to_be_removed> in the <string> with <string_to_be_placed>.
|
String.replaceFirst(user.firstName,"e","a")
The first occurrence of "e" will be replaced by "a". If a user's first name
is "Ellen", then the first occurrence of the character "e" in the name will be replaced by
"a", giving "Allen" as the output.
|
Substring
|
String.substring(<string>,<beginIndex>,<endIndex>)
|
Fetches the part of the <string> that is specified by the indexes.
|
String.substring(user.firstName,0,1)
The first and second characters from the user's first name will be fetched. If a user's first name is "John", then the string "Jo" will be returned.
|
To Lower Case
|
String.toLowerCase(<string>)
|
Converts all characters in the given string to lower case.
|
String.toLowerCase(user.firstName)
The characters in the user's first name will be converted to lower case. If a user's first name is "John", "john" will be returned.
|
To Upper Case
|
String.toUpperCase(<string>)
|
Converts all characters in the given string to upper case.
|
String.toUpperCase(user.firstName)
The characters in the user's first name will be converted to upper case. If a user's first name is "John", then "JOHN" will be returned.
|
Trim
|
String.trim(<string>)
|
Removes leading and trailing spaces in the given string. Can be used to sanitize fields that might have typos, or strings that were derived using other methods like substring.
|
String.trim(user.displayName)
The blank spaces, if any, will be removed. For example, if the full name of a user is " Johnson Doe", then the space before "Johnson" will be removed, and "Johnson Doe" will be returned.
|
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.