String manipulation

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: String manipulation
Date: 2003-07-28 20:56:13
Message-ID: 007601c3554a$aebcb750$32021aac@chad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I cannot seem to put this together properly.

I have a column path that has string data I want parsed out.

select path from paths

path
-------------------------------------
Canon:Canon Toner
Data Products:Data Products Toner
Epson:Epson Inkjet Cartridges
Tektronix by Xerox:Tektronix Ink Sticks

what i would like is something like this

Toner
Products Toner
Inkjet Cartridges
Ink Sticks

That is.... after the colon, find the first space and give the rest of the
string.

TIA for any ideas
Chad

Browse pgsql-novice by date

  From Date Subject
Next Message David Olbersen 2003-07-28 21:18:56 Re: String manipulation
Previous Message bruce 2003-07-28 19:19:34 Re: [PHP] Accessing Postgres db from apache using PHP