Hi David,
Thanks for this, but could you provide the full SQL statement.
BR
Danny
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of David
Gibbs
Sent: dinsdag 5 december 2017 15:39
To: RPG programming on the IBM i (AS/400 and iSeries)
<rpg400-l@xxxxxxxxxxxx>
Subject: Re: Using regex()
On 12/5/2017 8:09 AM, Danny Rodius wrote:
Have checked these scalar functions out. However a compare is not
included. Need to check if an email is valid.
Can you give an example of the expression & data and results you would like?
I found the REGEXP_INSTR function will tell me if a character field matches
the expression
Here's a really basic example I've used in the past ...
values(regexp_instr(
'david@xxxxxxxxxxxx',
'[A-Z0-9._%-]+@[A-Z0-9._%-]+\.[A-Z]{2,4}',
1,
1,
0,
'i'));
The returned value is 1.
david
--
David Gibbs
midrange.com
IBM i on Power Systems: For when you can't afford to be out of business!
I'm riding 615 miles (Yes, you read that right) in the American Diabetes
Association's Tour de Cure to raise money for diabetes research, education,
advocacy, and awareness. You can make a tax deductible donation to my ride
by visiting
https://list.diabetessucks.net.
See where I get my donations from ... visit
https://lsteml.diabetessucks.net/map for an interactive map (it's a geeky
thing).
I may have diabetes, but diabetes doesn't have me!
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
