This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Gather all 9 clues to complete the final Weekly Challenge on Dec 16!
Hello,Tableau has a veru useful "split" function that allows you to split a string with a delimiter and specify the number of the result you want
Qlik has the same function, subfield : https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...I think this is quite useful and a very standard feature.Best regards,Simon
Found this while looking for something else...I usually use the Text to Columns tool https://help.alteryx.com/current/TextToColumns.htm since it's point-and-click, then anything more complicated usually ends up as a Regex Tool.
Hello Jonathan,I usually use the TTC tool. However, I have a use case when I have to take the n (variable coming from macro input) result of the split with the y (variable, coming from a macro input) of the x(variable coming from the macro input)) field.The TTC tool means split a know field, getting all the results, deselect the one you don't want, etc... while it can be done within a single one simple formula.And in this use case, it's just a nightmare with the TTC tool.
You might find the Split function contained in this post useful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.