filter with regular expression
Posted: Tue Feb 13, 2007 7:39 am
Hello,
I tried to filter records from a table using the following regular expression:
idnummer like '[P-Q][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
(to get the idnummers that begin with P or Q directly followed by 7 digits).
However, when I run the job I get the following error:
Filter_3: Literal regular expression formatted incorrectly. Got: '[P-Q][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'.
idnummer has type varchar(8)
The strange thing is that when I trim the last [0-9] the expression seems valid: the job runs without error (although this is not what I want...)
Any ideas what goed wrong?
Peter
I tried to filter records from a table using the following regular expression:
idnummer like '[P-Q][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
(to get the idnummers that begin with P or Q directly followed by 7 digits).
However, when I run the job I get the following error:
Filter_3: Literal regular expression formatted incorrectly. Got: '[P-Q][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'.
idnummer has type varchar(8)
The strange thing is that when I trim the last [0-9] the expression seems valid: the job runs without error (although this is not what I want...)
Any ideas what goed wrong?
Peter