Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

"Split" function in formula

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

9 Comments
jdrummey
9 - Comet

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
13 - Pulsar

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
8 - Asteroid

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

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
NicoleJ
Alteryx
Alteryx
Status changed to: Accepted

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

simonaubert_bd
13 - Pulsar

Hello @NicoleJ 

Thanks, that's great news !

Best regards,

Simon

NicoleJ
Alteryx
Alteryx
Status changed to: Coming Soon

Stay tuned, coming soon! 😁

simonaubert_bd
13 - Pulsar

@NicoleJ  thanks !!

NicoleJ
Alteryx
Alteryx
Status changed to: Implemented

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