Btw, this is the RegEx builder I use to try and figure this stuff out:
http://gskinner.com/RegExr/
It's a Flex app, I believe, and is available as a desktop Air app as well.
Judah
On Wed, Apr 20, 2011 at 4:00 PM, Judah McAuley wrote:
> Your regex doesn't seem to work when I try it in a regex b
Your regex doesn't seem to work when I try it in a regex builder but I
can't see why it doesn't, it looks correct to me.
Judah
On Wed, Apr 20, 2011 at 12:07 PM, Jerry Milo Johnson wrote:
>
> I was thinking that the - at the front is a special case, as it can
> ONLY appear at the very front or n
I was thinking that the - at the front is a special case, as it can
ONLY appear at the very front or not at all. maybe pull it out?
^[-]?[0-9\.]*[0-9]+
or should I shut up and return to making php errors by the dozen?
On Wed, Apr 20, 2011 at 2:53 PM, Judah McAuley wrote:
>
> I just realized
I just realized that it probably needs one more revision to this:
^[0-9\.-][0-9\.]+[0-9]+
The problem with the previous one is that it would allow -. as a
number, which it obviously is not. The new regex requires the last
character to be a number. This should be fine in almost all
situations, so
Yeah, I think that Greg has it right. Didn't notice the bit where it
can't be a single dash but when I test the regex with a + instead of *
it does not match single dash.
^[0-9\.-][0-9\.]+
Judah
On Wed, Apr 20, 2011 at 10:58 AM, Greg Morphis wrote:
>
> That "*" means 0 or more, could you chang
That "*" means 0 or more, could you change it to "+" meaning 1 or more?
Since there has to be a number?
Regex is not my strong suit either
On Wed, Apr 20, 2011 at 12:21 PM, G Money wrote:
>
> Rats...it still allows just a single dash "-"
>
> On Wed, Apr 20, 2011 at 11:57 AM, Judah McAuley wrote:
Rats...it still allows just a single dash "-"
On Wed, Apr 20, 2011 at 11:57 AM, Judah McAuley wrote:
>
> Ok, here's what I've got so far before my meeting:
>
> ^[0-9\.-][0-9\.]*
>
> That says: start with a single character that is numeric, a period or
> a negative, then followed by any number of
Thanks Judah...you rock.
On Wed, Apr 20, 2011 at 11:57 AM, Judah McAuley wrote:
>
> Ok, here's what I've got so far before my meeting:
>
> ^[0-9\.-][0-9\.]*
>
> That says: start with a single character that is numeric, a period or
> a negative, then followed by any number of characters that is n
Ok, here's what I've got so far before my meeting:
^[0-9\.-][0-9\.]*
That says: start with a single character that is numeric, a period or
a negative, then followed by any number of characters that is numeric
or a period.
This seems to completely match 0.34, -0.34, -.34, .34 but fail for
.3-4,
On Wed, Apr 20, 2011 at 11:35 AM, Judah McAuley wrote:
>
> Hmm...would you want to make sure that there is a number between the
> dash and period? Would -.34 be valid? I'm trying to work on a regex
> (not my strong suit) while I wake up.
>
No, we wouldn't need a number between them, since "negat
On Wed, Apr 20, 2011 at 8:59 AM, G Money wrote:
>
> On Wed, Apr 20, 2011 at 10:52 AM, Judah McAuley wrote:
>
>>
>> Does it matter where in the field the dash or period is found? For
>> instance, does it have to start with a number or can it start with a
>> negative sign? Can it end with a period
On Wed, Apr 20, 2011 at 10:52 AM, Judah McAuley wrote:
>
> Does it matter where in the field the dash or period is found? For
> instance, does it have to start with a number or can it start with a
> negative sign? Can it end with a period or negative sign?
>
Good questioni don't think it
Does it matter where in the field the dash or period is found? For
instance, does it have to start with a number or can it start with a
negative sign? Can it end with a period or negative sign?
On Wed, Apr 20, 2011 at 8:28 AM, G Money wrote:
>
> The ISNUMERIC function in SQL Server returns a 1 o
The ISNUMERIC function in SQL Server returns a 1 on a field that contains a
single dash character ("-") or a single period character (".")
Anyway, this causes issues, obviously, since a "-" or a "." can't be
converted to a number for use in calculations with other numeric values.
We currently ru
14 matches
Mail list logo
