String Functions

1) ASCII:

It returns first letter of String's ASCII

ASCII(“Tableau”) =  84

2) Char: 

This function converts numerical number in to character.

EX: char(65)= A

3) Contains:

It will check whether substring is available or not in the main string.

It means it gives the Outputs as True/False

EX: 

Region = South

contains([Region], "st") = True

contains([Region], "k") = False

4) ENDWITH:

It will check whether substring is endswith or not in the main string.

It means it gives the Outputs as True/False

EX:ENDSWITH( [Region], 'st' )

Region = South

endwith([Region], "th") = True

endwith([Region], "k") = False

5) Find:

It will check the position of substring in the main string.

It means it gives the Outputs as Numerical Numbers.

Region = South

Find ([Region], "th") = True

Find ([Region], "k") = False

6) Findnth:

This function verifies the string & gives specified substring position 

for nth occurrence.

Findnth(“developer”,1,’e’)

Findnth(“developer”,’e’,1) = 2

Findnth(“developer”,’e’,2) = 4

Findnth(“developer”,’pe’,2) = 7

7) Isdate:

This is used to test the given string data, 

if given data is date then returns “True” else false.

EX: isdate(‘[Order_Date]’) =  True

Isdate(’12-Feb-2011’) = True

8) LEFT:

We use this function to fetch substring from starting point to 

specific point in the given Main String.

EX: Left([Customer Name],3)

Region = South

Left([Region],2) = So

9) LEN: 

This function count the number of characters including nulls & returns Numerical number.

10) MAX:

Test & returns Maximum as output.

Max(“A”, “B”)= B

Max(“AAAA”, “D”)= D

11) Min:

This function checks it gives minimum number as output as per 

first character’s ASCII value.

EX: Min ('A', 'B') = A

12) MID:

This function is used to extract the sub string from specific point 

to specific point.

EX: Region = South

Mid( [Region], 2,4) = out

13) Replace:

This function is used to replace the substring by other substring.

EX: replace([Region], “th”, “th Carolina”) = South Carolina

14) Right:

This function fetch the data up to specified number of positions 

from right side.

15) RTRIM:

This function removes empty space after the word, 

which means right side empty space.

16) Space:

This function is used to add the space in the word & 

defined number of times.

17) Stars with:
This function test whether string stars with specified substring, & 

returns Boolean.

18) Trim:

This function removes extra space of string for left & 

right edges of the given string.

19) Upper: It converts the given string into Upper Case.