Trimming functions in tableau

  In tableau 3 types of trimming functions are available.

 
        LTRIM

        RTRIM

        TRIM

LTRIM function removes the empty space from the left part of the input string.where as Rtrim removes the empty space from the right part of the string. where as Trim function eliminates empty spaces from both sides of the string.


            syntax:

             Ltrim(string)


             example:


                Ltrim(' tableau ') ='tableau '




            syntax

             Rtrim(string)


             example


                Rtrim(' tableau ') =' tableau'



         
            syntax

             Trim(string)


             example:


                trim(' tableau ') ='tableau'


                             Read more