community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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

Learn More
SOLVED

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:

 

InputOutput1Output2Output3
[abc]abc  
[abc]+[def]abcdef 
Substring([ghi], 3)+[jkl]+min([mno])ghijklmno

 

Anyone an idea?

 

Thanks

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.

 

Ben

Alteryx Partner

Great! Neat solution. Thanks Ben.

Labels