RE: parsing using sql help please
- From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
- To: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Jan 2012 11:03:49 -0800
Sorry, forgot to mention that I am running Oracle 9.2
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Eugene Pipko
Sent: Tuesday, January 10, 2012 10:59 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: parsing using sql help please
Hi all,
I need to be able to parse list of customers by first/last names.
The problems is that each name can come in many different ways.
For instance:
'Eugene Pipko'
'Eugene Pipko' -- many blanks in between
'Eugene A Pipko' -- mid initial with one space in between
'Eugene A. Pipko' -- mid initial with a dot and multiple spaces
I am thinking of getting first name using substr('Eugene
Pipko',1,instrt('Eugene Pipko',' ',1,1)) to start searching from the beginning
of the name.
Now, the last name can be found by looking backwards till the first blank, but
... I don't know how to do it. I can user substr() to search backwards, but I
need to find first blank starting from the end.
Can instr() be used to search in reverse?
[cid:image001.png@01CCCF86.CDDE0A70]
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
