Scribd
Upload
1 views1 page

3.String Functions

The document outlines various text/string functions used for string manipulation, including Len, Concatenate, Left, Right, Mid, Upper, Lower, Trim, Substitute, Replace, Blank, and CombineValues. Each function is briefly described with examples of how to use them on table columns. These functions are essential for handling and processing string data effectively.

Uploaded by

nandinimugadur
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1 views1 page

3.String Functions

The document outlines various text/string functions used for string manipulation, including Len, Concatenate, Left, Right, Mid, Upper, Lower, Trim, Substitute, Replace, Blank, and CombineValues. Each function is briefly described with examples of how to use them on table columns. These functions are essential for handling and processing string data effectively.

Uploaded by

nandinimugadur
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Text/String functions

Text/String functions :-
Len - Is used to find the length of the string. It will count spaces also.
LengthOfString = Len(TableName[ColumnName])

Concatenate - Is used to Concatenate more than one column.


ConcatenateString = Concatenate(TableName[ColumnName],TableName[ColumnName])

Left - To get number of letters from Left side.


StringLeft - left(TableName[ColumnName],5) -- 5 Letters from left side.
Right -To get number of letters from Right side.

mid - (Similar to substring)


Upper - UpperCase -Upper(TableName[ColumnName])
Lower - LowerCase -Lower(TableName[ColumnName])
Trim - Trim is used to remove spaces left side, Right side and Additional spaces in between.
TrimString = Trim(TableName[ColumnName])

Substitute - SUBSTITUTE(Emp[EmpName],"ActualWord","ReplaceWith",occuranceNumber)
Replace - REPLACE(Emp[PhoneNumber],6,5,'*****')
Blank - IF(Emp[NoOfDays]=0,Blank(),Emp[Salary]/Emp[NoOfDays])
CombineValues - It is used to combine values with delimiter.
Find - which is used to find position of string/symbol.
1
Page

THARUN CHALLA 1

You might also like