Subset of a string between characters

[RsRoel]

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:

Input	Output1	Output2	Output3
[abc]	abc
[abc]+[def]	abc	def
Substring([ghi], 3)+[jkl]+min([mno])	ghi	jkl	mno

Anyone an idea?

Thanks

[BenMoss · Accepted solution]

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

[RsRoel]

Great! Neat solution. Thanks Ben.