"Split" function in formula

[simonaubert_bd]

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/StringFunc...

I think this is quite useful and a very standard feature.


Best regards,

Simon

[jdrummey]

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

[simonaubert_bd]

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.

[BetterFerret]

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

[NicoleJ]

Thanks for the great idea! We're including this on the list of additional functions we're adding in Designer. Stay tuned! 😁

[simonaubert_bd]

Hello @NicoleJ 

Thanks, that's great news !

Best regards,

Simon

[NicoleJ]

Stay tuned, coming soon! 😁

[simonaubert_bd]

@NicoleJ  thanks !!

[NicoleJ]

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-not...