DOH: The Qbarcode field is a query field, the second instance of it was
correctly using the query scope but was then setting it in the variables
scope, how stupid do I feel!
Oh well, more caffeine then ;-)
--
Jay
> -Original Message-
> From: Pascal Peters [mailto:[EMAIL PROTECTED]
> Sent: 15 July 2004 13:07
> To: CF-Talk
> Subject: RE: Using RegEx to strip any character that isn't a number
>
> It shouldn't. The only thing I can think of is that you are
> in a cfoutput/cfloop query and that QBarcode is one of your
> fields. If this is the case, the problem should disappear if
> you use the proper prefixes for your variables!
>
> Pascal
>
> > -Original Message-
> > From: James Smith [mailto:[EMAIL PROTECTED]
> > Sent: 15 July 2004 13:16
> > To: CF-Talk
> > Subject: Using RegEx to strip any character that isn't a number
> >
> > OK, I must be suffering a caffeine deficiency this morning as I just
> can't
> > seem to get the following to do it's job.
> >
> >
> >
> > Should this not take the QBarcode field and return it to me with
> numbers
> > only, ie: '1234567890123 becomes 1234567890123. The
> problem is mostly
> > caused by a leading ' character used by excel to stop it trimming
> leading
> > zeros from a barcode field, however the regex above is leaving the
> > apostrophe untouched.
> >
> > Any ideas?
> >
> > --
> > James Smith
> > [EMAIL PROTECTED]
> >
> >
> >
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]