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
https://onlinehelp.tableau.com/current/pro/desktop/en-us/functions_functions_string.htm
Qlik has the same function, subfield : https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/SubField.htmI 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.
Jonathan
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
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Custom-Functions/idi-p/467216#M9578
Thanks for the great idea! We're including this on the list of additional functions we're adding in Designer. Stay tuned! 😁
Hello @NicoleJ Thanks, that's great news !Best regards,Simon
Stay tuned, coming soon! 😁
@NicoleJ thanks !!
We've implemented a few new formula functions in 23.2 release, including GetPart (our rename for "Split")... along with GetLeft & GetRight, you've got a few new options for string parsing to check out!
https://help.alteryx.com/current/en/release-notes/designer-release-notes/designer-2023-2-release-notes.html
