String Functions : Len, Left, Right
Hi All,
We are trying to use the string functions Len, Left, Right on a Campaign List Contact BC...
We have done the below config....
Sno
Force Case
Data type
Field Name
Calculated Value
1
DTYPE NUMBER
Length First Name
Len([Contact First Name])-1
2
LOWER
Right First Name
Right([Contact First Name],[Length First Name])
3
Final First Name
Left([Contact First Name],1)+[Right First Name]
4
DTYPE NUMBER
Length Last Name
Len([Contact Last Name])-1
5
LOWER
Right Last Name
Right([Contact Last Name],[Length Last Name])
6
Final Last Name
Left([Contact Last Name],1)+[Right Last Name]
7
First Name
IIF([Contact Id] IS NOT NULL, [Final First Name], [Prospect First Name])
1