3 Replies Latest reply on Jul 5, 2018 4:26 PM by Ken Flerlage

    How to do text to column in Tableau similar to the function available in excel?

    Tony Fahd

      so i am attaching a workbook where i have my customer name and ID. i have million of customers. customer name and ID and concatenated together but i like to separate the ID from customer name. below is a screenshot that shows what i like to accomplish.

       

      i like to pull their IDs only without the name and parentheses. some customers have a comma between first and last name and some don't. the screenshot below shows how i like to separate the ID from name. (i did this manually)

       

      and help is appreciated. workbook attached.