Pages: [1]
  Print  
Author Topic: [SOLVED] How to use '[' as split pattern in Split Operator  (Read 705 times)
capson
Newbie
*
Posts: 8


« on: September 13, 2013, 01:45:10 PM »

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
« Last Edit: September 13, 2013, 04:38:07 PM by capson » Logged
François-Paul Servant
Newbie
*
Posts: 2


« Reply #1 on: September 13, 2013, 04:30:23 PM »

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
Logged
capson
Newbie
*
Posts: 8


« Reply #2 on: September 13, 2013, 04:37:36 PM »

That is good to know, it worked.

Many thanks!
Logged
Pages: [1]
  Print  
 
Jump to: