REX needed

Post Reply
chand012
Posts: 70
Joined: Mon Dec 18, 2000 4:34 pm

REX needed

Post by chand012 »

This seems simple, but I can't get the right REX expression. I need to query a table and return rows where a specific column value begins with a digit. I have tried " ... like '/^\digit+.*'" but it returns nothing (I know there are such values because " ... matches '1%'" returns 2 rows).
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

REX needed

Post by John »

The correct expression would be:

/>>=\digit

The "^" matches the beginning of a line, and looks for the line-feed, which isn't there.
John Turnbull
Thunderstone Software
Post Reply