> -----Original Message-----
> >
> > Hi All
> >
> >
> >
> > Got a weird one. I am using the regex below to case match numeric only
> values.
> >
> >
> >
> > '^([0-9]+[.]?[0-9]*)$'
> >
> >
> >
> > This works well by and large but not for a value like “1234:567”. This seems
> to match positive and then fails due to not being an actual number in the
> subsequent cast.
> >
> >
> >
> > Any ideas? (PG13)
> >
> >
> >
> > Z
> >
> >
My apologies for wasting your time ☹
The issue was in an unrelated field!!
Thank you
Z