Sponsored Content
Full Discussion: Regexp_instr
Top Forums Programming Regexp_instr Post 302256942 by vijay_0209 on Tuesday 11th of November 2008 12:07:51 AM
Old 11-11-2008
Regexp_instr

I need to select all those values with....



REGEXP_INSTR(column_name,'^((A){0,1}[[:alpha:]]+[. | ]?)+[[:digit:]]+[-|/]?[[:digit:]]*$') = 0





But with " ^((A){0,1} " at the begining it seems to take a lot time.....it goes on infinitely



i also tried the following but in vain.....



'^([A]?[[:alpha:]]+[. | ]?)+[[:digit:]]+[-|/]?[[:digit:]]*$'

'^([ABC]?[[:alpha:]]+[. | ]?)+[[:digit:]]+[-|/]?[[:digit:]]*$'

'^([ABC]*[[:alpha:]]+[. | ]?)+[[:digit:]]+[-|/]?[[:digit:]]*$'

'^((A){0,}[[:alpha:]]+[. | ]?)+[[:digit:]]+[-|/]?[[:digit:]]*$'

'^((A){0,1}[ABC]?[[:alpha:]]+[. | ]?)+[[:digit:]]+[-|/]?[[:digit:]]*$'

'^([A-Z]*[[:alpha:]]+[. | ]?)+[[:digit:]]+[-|/]?[[:digit:]]*$'

'^((A){0,1}[A-Z]+[. | ]?)+[[:digit:]]+[-|/]?[[:digit:]]*$'






provide some alternatives...
 
ISWDIGIT(3)						     Linux Programmer's Manual						       ISWDIGIT(3)

NAME
iswdigit - test for decimal digit wide character SYNOPSIS
#include <wctype.h> int iswdigit(wint_t wc); DESCRIPTION
The iswdigit() function is the wide-character equivalent of the isdigit(3) function. It tests whether wc is a wide character belonging to the wide-character class "digit". The wide-character class "digit" is a subclass of the wide-character class "xdigit", and therefore also a subclass of the wide-character class "alnum", of the wide-character class "graph" and of the wide-character class "print". Being a subclass of the wide character class "print", the wide-character class "digit" is disjoint from the wide-character class "cntrl". Being a subclass of the wide-character class "graph", the wide-character class "digit" is disjoint from the wide-character class "space" and its subclass "blank". Being a subclass of the wide-character class "alnum", the wide-character class "digit" is disjoint from the wide-character class "punct". The wide-character class "digit" is disjoint from the wide-character class "alpha" and therefore also disjoint from its subclasses "lower", "upper". The wide-character class "digit" always contains exactly the digits '0' to '9'. RETURN VALUE
The iswdigit() function returns nonzero if wc is a wide character belonging to the wide-character class "digit". Otherwise, it returns zero. ATTRIBUTES
For an explanation of the terms used in this section, see attributes(7). +-----------+---------------+----------------+ |Interface | Attribute | Value | +-----------+---------------+----------------+ |iswdigit() | Thread safety | MT-Safe locale | +-----------+---------------+----------------+ CONFORMING TO
POSIX.1-2001, POSIX.1-2008, C99. NOTES
The behavior of iswdigit() depends on the LC_CTYPE category of the current locale. SEE ALSO
isdigit(3), iswctype(3) COLOPHON
This page is part of release 4.15 of the Linux man-pages project. A description of the project, information about reporting bugs, and the latest version of this page, can be found at https://www.kernel.org/doc/man-pages/. GNU
2015-08-08 ISWDIGIT(3)
All times are GMT -4. The time now is 11:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy