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

    Adam Hart

    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

    Adam Hart                 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

    Adam Hart                 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

    Adam Hart                 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

    Adam Hart                       0

    Sung Park                       0

    Susan Pistek                   5

    Alan Hwang                     4

    Barry Franz                    10

    Bart Folk                        0

    Dionis Lloyd                    4

     

    Thanks & Regards

    Laxman Kumar