Thread: help
Hi,<br /><br />I have a table in which the data's are entered like,<br /><br />Example:<br /><br />One (1)<br />Two (2)<br/>Three (3)<br /><br />I want to extract the data which is only within the parentheses.<br /><br />that is <br />1<br/>2<br /> 3<br /><br /><br />Thank You<br />Nicholas I<br /><br />
select substring( data from '\((.*)\)' ) from table; 2010/5/5 Nicholas I <nicholas.domnic.i@gmail.com>: > Hi, > > I have a table in which the data's are entered like, > > Example: > > One (1) > Two (2) > Three (3) > > I want to extract the data which is only within the parentheses. > > that is > 1 > 2 > 3 > > > Thank You > Nicholas I > > -- Filip Rembiałkowski JID,mailto:filip.rembialkowski@gmail.com http://filip.rembialkowski.net/
Or even simpler, or easier to understand:
SELECT trim(foo, '()') FROM foobar
pozdrowienia / regards / salutations
mk
2010/5/5 Nicholas I <nicholas.domnic.i@gmail.com>
Hi,
I have a table in which the data's are entered like,
Example:
One (1)
Two (2)
Three (3)
I want to extract the data which is only within the parentheses.
that is
1
2
3
Thank You
Nicholas I