[GRASSLIST:3789] Re: Fun with dbf in GRASS57

SWlab swlab at cornell.edu
Wed Jun 30 09:30:52 EDT 2004


> > I had a similar question and Radim pointed me to this brief but useful
> > guide in the GRASS 5.7 manual. Here is the address for the on-line
> > version.
> >
> > <http://grass.itc.it/grass57/manuals/html57_user/sql.html>

YES ! Thansk a lot !

> WHERE HUC_11 ~ '02040101%' could work.

AAMOF, it does not. The "~" operator works like in gawk (it seems), you don't 
need the wildcards, and so the proper answer is

WHERE HUC_11 ~ '02040101' 

Well, new problem: you can't precise what part of the string to match (start? 
end?), I guess that comes from the dbf driver limitations... Fair enough.

Thanks again !

-- 
Soil & Water Laboratory
Dept. of Biological & Environmental Engineering
Cornell University
ITHACA, NY 14853
Tel: (607)255.2463




More information about the grass-user mailing list