# Few String Calculated Functions

Version 2

This Document is created intent to know usage & syntax of Main String Calculation Functions (Not all string Calculation Functions).

The below link is has example of String Calculations. (It is in Progress)

I am taking the Following Column & Values as Example to explain in this Document.

And Packaged workbook is located @ String Calculated Functions

Customer Name

Aaron Bergman

Aaron Smayling

Sung Park

Susan Pistek

Alan Hwang

Barry Franz

Bart Folk

Dionis Lloyd

1) Contains:

We use this function to know whether main string has sub string, It gives Boolean as Out put, it means Yes or No.

Note: This function ignores case, it means it treats lower case And Upper cases are same.

contains([Customer Name], "a") = contains([Customer Name], "A")

EX:

Name: Customer Names having letter 'a'

Syntax: contains([Customer Name], "a")

Customer Name     Customer Names having letter 'a'

Aaron Bergman          True

Aaron Smayling          True

Sung Park                  True

Susan Pistek              True

Alan Hwang                True

Barry Franz                True

Bart Folk                    True

Dionis Lloyd               False

2) Endswith

This function check whether any string is endswith any specified sub-string, it gives us  O/P as "True" , "False".

Note: This function ignores case, it means it treats lower case And Upper cases are same.

EX:

Name: Customer Names Endwswith 'K'

Syntax: endswith([Customer Name], 'k')

Customer Name     Customer Names having letter 'a'

Aaron Bergman          False

Aaron Smayling          False

Sung Park                  True

Susan Pistek              True

Alan Hwang                False

Barry Franz                False

Bart Folk                    False

Dionis Lloyd               False

EX: 2

Name: Customer Names Endwswith 'man'

Syntax: endswith([Customer Name], 'man')

Customer Name     Customer Names having letter 'a'

Aaron Bergman          True

Aaron Smayling          False

Sung Park                  False

Susan Pistek              False

Alan Hwang                False

Barry Franz                False

Bart Folk                    False

Dionis Lloyd               False

3) Find:

This function will find the position of specified sub string in the given string.It gives O/P Numerical Numbers.

Note: This function ignores case, it means it treats lower case And Upper cases are same.

EX:

Name:  Find position of 'n'

syntax:

find([Customer Name], 'n')

Customer Name          Find position of 'n'

Aaron Bergman                5

Aaron Smayling                5

Sung Park                       0

Susan Pistek                   5

Alan Hwang                     4

Barry Franz                    10

Bart Folk                        0

Dionis Lloyd                    4

Thanks & Regards

Laxman Kumar