String Concatenation
|
Function Name Example |
Parameters Results |
|---|---|
|
+operator |
str1 - string str2 - string |
|
FirstName + LastName |
'John Smith' |
String Concatenation
|
Function Name Example |
Parameters Results |
|---|---|
|
Concat(str1, str2, separator) |
str1 - string str2 - string separator - string |
|
Concat('Hello','world',', ') |
'Hello, world' |
Sub String
|
Function Name Example |
Parameters Results |
|---|---|
|
Substr(str,from,to) |
str - the string from - starting offset of requested substring to - ending offset of requested substring |
|
Substr('John Smith',5,6) |
'Sm' |
String Trimming
|
Function Name Example |
Parameters Results |
|---|---|
|
Trim(str) |
str - string with leading/ending spaces |
|
Trim(' sentence between many spaces ') |
'sentence between many spaces' |
String Last Characters
|
Function Name Example |
Parameters Results |
|---|---|
|
LastChars(str,len) |
str - string len - integer value specifying the required length of the tail |
|
LastChars('where is the end',7) |
'the end' |
String Length
|
Function Name Example |
Parameters Results |
|---|---|
|
Strlen(str) |
str - string |
|
Strlen('hello world') |
11 |
String Searching
|
Function Name Example |
Parameters Results |
|---|---|
|
StrFind(str,substr) |
str - string substr - the string which we need offset of |
|
StrFind('My favorite color is red','color') |
12 |
Convert from Integer to String
|
Function Name Example |
Parameters Results |
|---|---|
|
StrOf(int) |
int - integer value |
|
StrOf(5) |
'5' |
Finding Digits in a String
|
Function Name Example |
Parameters Results |
|---|---|
|
DigitsOf(str) |
str - string |
|
DigitsOf('john12smith34') |
'1234' |
Replacing Strings
|
Function Name Example |
Parameters Results |
|---|---|
|
StrReplace(strSource,substr,replacing) |
strSource - source string substr - the substring to be replaced replacing - the new sub-string |
|
StrReplace('firstname1lastname1','1','2') |
'firstname2lastname2' |
Finding Alphabetic Characters
|
Function Name Example |
Parameters Results |
|---|---|
|
AlphaOf(str) |
str - string |
|
AlphaOf('a1!@b2#$A1%^B2') |
'abAB' |
Finding Alpha-Numeric Characters
|
Function Name Example |
Parameters Results |
|---|---|
|
AlphaAndDigitsOf(str) |
str - string |
|
AlphaAndDigitsOf('a1!@b2#$A1%^B2') |
'a1b2A1B2' |
Lower Case Conversion
|
Function Name Example |
Parameters Results |
|---|---|
|
ToLower(str) |
str - string |
|
ToLower('RRYMON') |
'rrymon' |
Upper Case Conversion
|
Function Name Example |
Parameters Results |
|---|---|
|
ToUpper(str) |
str - string |
|
ToUpper('rrymon') |
'RRYMON' |
Two-way Case Conversion
|
Function Name Example |
Parameters Results |
|---|---|
|
SwapCases(str) |
str - string |
|
SwapCases('RRymon') |
'rrYMON' |
Removing Vowels from a String
|
Function Name Example |
Parameters Results |
|---|---|
|
RemoveVowels(str) |
str - string |
|
RemoveVowels('johnSMITH') |
'jhnSMTH' |
Left-to-Right Reversing
|
Function Name Example |
Parameters Results |
|---|---|
|
Reverse(str) |
str - string |
|
Reverse('john SMITH') |
'HTIMS nhoj' |
|
Copyright © 2014 CA.
All rights reserved.
|
|