1 of 1 people found this helpful
You need to ETL this outside of Tableau, I think.
I tried to edit the data source to see if I could use the SPLIT function. (Maybe there is a way to exclude a split condition, given that there is only one situation where there are commas embedded in the data.) But even that was thwarted because editing the data source wants me to log into google-something-or-other.
Yes - I've spent a lot of time staring at this now and I don't think I have any options that aren't at least somewhat manual. I can probably make the split manually in Excel then connect that to Tableau. I was hoping for some magic, but there's just no way to tell Tableau (or any other tool) to split text on a delimiter in some cases but not others.
Thanks for trying! I'll make it work - it will just take longer than I had hoped it would.