[GRASS-user] change some labels to upper/lower case in vector attributes

GRASS GRASS user
1

One column of my vector is the name of the town all in uppercase.
What I want is to convert them, i.e.,

SAN DIEGO > San Diego

My grass dbase is sqlite
--
cheers,
maning
------------------------------------------------------
"Freedom is still the most radical idea of all" -N.Branden
wiki: http://esambale.wikispaces.com/
blog: http://epsg4253.wordpress.com/
------------------------------------------------------

2

On 17/08/09 08:19, maning sambale wrote:

One column of my vector is the name of the town all in uppercase.
What I want is to convert them, i.e.,

SAN DIEGO > San Diego

My grass dbase is sqlite

Something like this should do the trick (untested):

UPDATE YourTable set town=substr(town,1,1) || lower(substr(town,2))

Moritz

3

Thanks will try this one.

On Tue, Aug 18, 2009 at 7:36 PM, Moritz
Lennert<mlennert@club.worldonline.be> wrote:

On 17/08/09 08:19, maning sambale wrote:

One column of my vector is the name of the town all in uppercase.
What I want is to convert them, i.e.,

SAN DIEGO > San Diego

My grass dbase is sqlite

Something like this should do the trick (untested):

UPDATE YourTable set town=substr(town,1,1) || lower(substr(town,2))

Moritz

--
cheers,
maning
------------------------------------------------------
"Freedom is still the most radical idea of all" -N.Branden
wiki: http://esambale.wikispaces.com/
blog: http://epsg4253.wordpress.com/
------------------------------------------------------