[SOLVED] How to use '[' as split pattern in Split Operator

capson

I have data that comes from LimeSurey looking like: stuff [other stuff] so in my table I have a field I want to split

Example
field1
stuff [other stuff]
stuff [other stuff]
stuff [other stuff]

Trying to get
field1   field2
stuff    other stuff]
stuff    other stuff]
stuff    other stuff]


I am using the split operator were my split pattern is the open square bracket [
The operator will not allow this as a split pattern

I have:
attribute filter type = single
attribute = field1
split pattern = [

I get Error:
The regular expression [ is not well defined: Unclosed character class near index [

Is thier anyway to force the split operator to use [ as a split pattern?

Thanks

Fran_ois-Paul_S

just a guess: did you try to escape it with an anti-slash? (that is, using "\[" instead of just "[")
[ is a metacharacter in a regex, and escaping is the standard way to use such a char in a search. I didn't try, however.
HTH
fps

capson

That is good to know, it worked.

Many thanks!