Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How can I find a space in a text string

Re: How can I find a space in a text string

From: Dennis M. Heisler <dheisler_at_binghamton.edu>
Date: Fri, 18 Aug 2000 20:27:48 -0400
Message-Id: <10593.115029@fatcity.com>


Look at the INSTR() function. Its usage is instr(char1, char2 [,n[,m]]). It will search char1 starting at position n for the mth occurrence of char2.

Dennis

Helmut Daiminger wrote:

> Hi all!
>
> How can I find the first blank space in a given text string?
>
> E.g.: "VISA 123456789"
>
> I want to find the first blank (space) in the text string and then cut out
> the left part of the string (in the example: VISA).
>
> How do I do that?
>
> Thanks,
> Helmut
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Fri Aug 18 2000 - 19:27:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US