There are two ways to perform to Split text by any word delimiter
1. By Text to Column option:
There is a limitation to perform the required result with this option as delimiter should have only one character/symbol. Hence, we need to go back to one more step where we use Replace option to replace delimiter word (in this example “-tds”) with one symbol(lets, say “@”).
Steps includes :
- Select the column list you want to split by “-tds” delimiter.
- Press Ctrl +H and replace “-tds” with “@”. Press Replace All.
It will replace “-tds” to “@” in all selected cells. Then, use Text to Columns option to split the text with delimiter “@”.
- Select the column list you want to split by “@” delimiter and click Data > Text to Columns.
- Then a Convert Text to columns Wizard dialog pops out, and check Delimited option, and click Next button.
- You need to split your text string by a special delimiter, please check the Other option, and then type the delimiter into following box (here “@”).
Click Finish. Now you can see the column list in selection has been split into multiple columns by “@” delimiter.
Alternatively,
2. Second by formula which gives the same result :
below is the second way to Split text by any word delimiter is using by excel formula
=LEFT(D2,FIND("-tds",D2)-1)
Below are the few more chart can be created in tableau, steps wise guide for easy to design.
Butterfly Bar Chart in Tableau
Create YTD & Full Year Filter Option In Tableau