The Split function in Tableau.

[@saydeeztee]

Hi Tim. I need to split using comma; however, there are instances of text (with double quotation text qualifiers) that contain a comma within the text object. How would you handle that split? Example: {"Name":"John Smith, Jr.","Age":6,"Weight":45,"Hometown":"Pleasantville"} --John Smith, Jr. should remain in one column (and not split off Jr.)

[@RonenLin]

Can you dynamically split? For instance I have several records with 5, 6,7 or 8 words and I want to split them on the space " " and create a column for each word.

[@TableauTim]

Yes. Bear in mind it's only dynamic if you can clearly describe the logic for why they split in different places. If so then you just use a logical statement to apply the correct split to the correct rows.

[@chiemeriechibuzor3989]

hi Tim, I can't find the split function. I am trying to create maps, to separate city from the state , but I can't find spilt function, I see only hide, create and duplicate..... oh thanks so much Tim, I have seen it. I seem to be using an old tutorial

[@eoa6755]

Hello Tim, thanks for your insightful videos. I need your help to split up my time datas. 1:30am or pm was writing as 130 and 4:00 am was given as 400 without any delimiters. please how can this be resolved. Thanks

[@amgadnassif2902]

Hi Tim....Can we do word slice then filter on the slice as we do in PANDAS? for example if I want to know the names that start with First Initial , in pandas I would use slice , then filter using the LOC function on the names that has a period or a space in position 1 where first letter comes in position ZERO and the second letter in position 1

[@brianbruno4449]

Hi Tim, I have some invalid data in my city category and the reason they are invalid is because they aren't cities but rather census. I want to create a split where I split my invalid string names from city and have a new column named census. But not quite sure how to do it

[@TableauTim]

This feels more like a manual job unless theres a consistent way or tag or flag that can identify which rows need the split operation done. If so then simply create a logical if calc to only split when a flag or a condition is met or for those cities you can manually assign their location using the mapping features. help.tableau.com/current/pro/desktop/en-us/maps_editlocation.htm

[@Mohammad-rz7oj]

Hi Tim, Could you please help in my requirement "i have a column which i am splitting with help of '-' but what happening is that for some rows i have two hyphens like this '--'. for example : lets i have two rows like 1) Paper-Pen 2) paper--pen' for this two rows if split basing on '-' we only get 1st row correctly like Pen but for 2nd row we will blank". I hope you got it. Please help me to solve such issues like this.

[@TableauTim]

Hi mohammad have you have you tried a conditional split? so owrite a formula that find any "--" splits one way then another formula that splits for "-" you can look at the formula for any split calculation to find out how Tableau writes the formula.

[@Owanango]

Hi Tim, this is cool stuff. How do you get it to return the default if unable to split? This happens in cases where the columns contain texts that either contain the character or is missing the character. For example if the character I am using to split is missing, how do I get it to return the "unsplit" text? I hope I am making sense. In other words, it is something like, if you are unable to split, return the previous string as-is. Thanks