(解决)如何使用“[”分裂的分裂模式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!