Wikidot Community

Ed,
There is a minor error in your code: it would accept one flight coordinate ending with semi-colon.

See also: http://community.wikidot.com/glossary:regex

Ed, There is a minor error in your code: it would accept one flight coordinate ending with semi-colon.

Hmmm. That's odd. I didn't test it in a dataform. I was testing it using the built-in checker on the web site I linked to above and it seems to work. However, dealing with the trailing semi-colon seemed to be a bit trickier.

Sorry, Phil! I tried!

If you or someone else doesn't figure it out, I'll take another stab at this when I have more time to test it in an actual dataform.

One thing that might make it easier is to create 5 fields and make fields 2-5 optional. Then you could apply [A-Z]{2}[0-9]{6}; as the match for the first 4 fields and [A-Z]{2}[0-9]{6} for the last one.

Edit: Just realized that wouldn't work unless all 5 fields are populated. Nevermind…

-Ed

its all good fun this isn't it :-)
thanks for having a crack at it Ed.

Oh ya, this is my kind of party! :)

A couple of questions:

1. Should the 2 letters be forced to upper case? Your example has "ee123456" and I suspect that was a typo.
2. Will there always be at least one flight co-ord?
3. Is it important that the list of flight co-ords does not have a trailing semi-colon, regardless of how many are listed?
   • For example, you want this: AA123456;BB123456 and not AA123456;BB123456; if there are only 2 flights listed.

Oh ya, this is my kind of party! :)

In which case, you do the thinking and I'll do the drinking and womanising :-)

there will be at least 2 sets (start and finish flight - the others -up to three-will be turn points if used)
yes they should be caps, eg AA not aa

the semi colon is a separator, so not required at the end of the co-ords. (as you guessed)
(the results are copy / paste into a sorting prog. this generates the tables.

I'm ready to join you in a drink and being silly with the women…

I've tested this and it works for me. I can't make it accept anything incorrectly (based on what I understand your need to be).

  Flight-co-ords:
    label: Your Flight Co-ords 
    type: text
    width:70
    hint:  AA123456;BB123456;CC123456;DD123456;EE123456
    match: /^([A-Z]{2}[0-9]{6};){1,4}([A-Z]{2}[0-9]{6}){1}$/
    match-error: please enter in the format AA123456;BB123456; ... ;EE123456 - Max of 5 co-ords and no trailing ";"

-Ed

Did it work? I'm getting awfully thirsty over here! :)

Sorry ed… been a bit busy fitting stripping out old kitchen for the woman..

Just added your code whilst she goes shopping for a few mins.

initially i though that it didn't work. But then i realised that i wasn't using caps for the letters…. DOH!

So it other words..
it works perfectly, exactly how i want it to work.

Many many thanks Ed. Your a star.

Glad to help. I'm not a star, I just keep battling (and Googling) until I can figure stuff out. Even though regex is like trying to read hieroglyphics for me, it's something I'd like to understand better. Plus, I'm always a sucker for a good problem-solving exercise! My wife tells me it'll help combat mad cow disease in my old age. 8-)

i have a feeling after all that, that i can't use the error checking code because it makes the co-ords field "required"
Which i don't want to do.
bum.

the other thing i found out was that other than the "url" field, and unlike mail form, there is no "required" function.
feature request has been added to "wishes".

I ran into the same thing while playing with forms a while ago and TeRq showed me how to use an "or" option with regex so that the field can be left blank or must match the correct format. Replace your match string with this and it should allow saving the form with a blank field.

match: /^$|^([A-Z]{2}[0-9]{6};){1,4}([A-Z]{2}[0-9]{6}){1}$/

If you want to make any field required, but don't care what's entered as long as there's at least one character, use this for your match. This means "there must be something in this field as long as it's not a space in the first character".

match: /\S/