Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Subset of a string between characters

Alteryx Partner

I'm looking at creating a subset of a string that falls between certain characters: '[' and ']' in this case. I played around with Regex but couldn't figure it out up till now, as in certain cases there are more subsets within a single field.


For example:


Substring([ghi], 3)+[jkl]+min([mno])ghijklmno


Anyone an idea?



Alteryx Certified Partner
Alteryx Certified Partner

When I cannot figure something out with Regex I try and think about how I would solve the problem without the Regex tool.


I've provided a solution here which gets your answer using the text to columns.



Alteryx Partner

Great! Neat solution. Thanks Ben.