12 Replies Latest reply on Dec 10, 2013 8:12 AM by Bob Nims

    Find last name in a full name

    Juracy Americo

      Hi guys , there are any way in Tableau to find what is the last name in a full name ?

      For the first name I used a calculated field as LEFT([Name],FIND( [Name]," ") ) but I cound't find a way to find a last name.


      Let use this example :

      I have the full name ABRAAO MOREIRA GADELHA and I'd like to find the last name GADELHA by a calculated field.


      In the Attach file I have a data sample


      Thank you in advanced.