Re: Issue with regular expressions.

[VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx>]

It might help others to know how you figured it out. In fact, I know it would.


Regards
Vern


On Tue, 25 Jul, 2023 at 11:54 AM, Jason Olson <josys36@xxxxxxxxx> wrote:
 

To: rpg programming on ibm i

Never mind. I figured it out.


On 7/25/23 11:33, Jason Olson wrote:
> I'm trying to use regular expressions to validate that an IP address 
> is valid.
>
> When I do this,
>
> exec sql
> select
>  REGEXP_COUNT('192.168.140.230<http://192.168.140.230>', :ip_regex)
>  into :count  from SYSIBM.SYSDUMMY1;
>
> It's working fine. However, if I use a variable to hold the IP address 
> it fails. I've tried char fields and varchar fields and it always 
> fails. This is on 7.3.