1 of 1 people found this helpful
It does appear to be a current limitation of Tableau Prep. I do hope to see it addressed in future releases. Please vote here to lend your support to removing the restriction: https://community.tableau.com/ideas/9033
There might be a possible workaround with the REGEXP_EXTRACT_NTH() function to find the 10th instance of the semicolon along (and surrounding characters) and replacing that with something that can then be used to split out the field into two fields of less than 10 semicolons each that could then be individually split without exceeding the limit - but what a mess and I'm not entirely certain it would work without really working through all the steps. Maybe better would be to split by length of the field.