Juan Miguel Garijo wrote: > In a vector map there is a text field with values > like: > > xxxx > xxxx > xxxx* > xxxx(*) > > I need to select all values wich finish with '*' OR > '(*)' > > (without '') > > Wich 'where' clause can I use in v.extract? > I see that is not the same if you write it in console > or throu gis.m > > Driver:dbf
I don't know if there is a regex '$'-like character in SQL to denote end of string match, but you can use where COLUMN ~ '*' to select strings which contain a '*' (? perhaps; I'm no SQL expert) try looking in the SQL reference guide: http://www.redhat.com/docs/manuals/database/RHDB-2.1-Manual/sql/sqlreference.html Hamish ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
