Newbie Questions

Re: Validation help

smods — Fri, 30 Jan 2009 23:45:59 GMT

Sorry to bother you Jimmy but can you help?

Re: Validation help

smods — Mon, 26 Jan 2009 09:27:53 GMT

Jimmy you are a genius! Thanks :D Can you also tweak the code so that numbers and apostrophes are allowed?

Can you also tell me what I need to set in other fields so that each new word starts with a capital letter? Similar to the proper function in Excel.

Cheers

Chris

Re: Validation help

Jimmy — Sat, 24 Jan 2009 01:11:11 GMT

How's this:

(\p{L}(\-\p{L})?)+\.(\p{L}(\-\p{L})?)+@((hotmail|live)\.co\.uk|hotmail\.com)

This one requires a first and last name separated by a period, where the first and last name can optionally contain hyphens, but not two hyphens in a row, and no hyphen at the beginning or end of a name.

Re: Validation help

smods — Fri, 23 Jan 2009 22:30:46 GMT

Thanks Jimmy, works a treat. How would the code change to make a decimal point mandatory?

So I want

name.surname@live/hotmail.co.uk/hotmail.com

Re: Validation help

Jimmy — Fri, 23 Jan 2009 11:52:31 GMT

This expression should do the trick:

(\p{L}+([_\-\.]|\d)*)+@((hotmail|live)\.co\.uk|hotmail\.com)

Re: Validation help

swathip — Fri, 23 Jan 2009 11:50:45 GMT

Hi,

Try the following expression in the data validation of the email text box.

not(xdUtil:Match(string(.), ".+@hotmail.com")) and not(xdUtil:Match(string(.), ".+@hotmail.co.uk")) and not(xdUtil:Match(string(.), ".+@live.co.uk"))

Re: Validation help

smods — Fri, 23 Jan 2009 10:07:50 GMT

I've been messign around with this but cannot get this to work. Any ideas?

Thanks

Re: Validation help

ErnestoM — Tue, 13 Jan 2009 15:05:10 GMT

In the past I have used the following pattern for emails. It allows dots in the prefix. Perhaps, when combined with your pattern for hotmail/live in the suffix, you can come up with the desired result.

(\p{L}+_*-*\p{L}*\d*\.?)+@(\p{L}+-*\p{L}*\.?)+

Good luck!

Validation help

smods — Tue, 13 Jan 2009 12:48:51 GMT

Hi all,

I have been messing with the data validation on my form and I am not having much luck!

I want my e-mail address field to only accept certain domains.

So I want to say if last half of the e-mail address does not end "@hotmail.com", "@hotmail.co.uk" or "@live.co.uk" then it's not a valid e-mail address.

I did this in the validation and it wouldn't accept it because of the prefix. Although the field contained "@hotmail.co.uk" it didn't like the text prioir to it

(i.e. john.smith@hotmail.co.uk)

How do I overcome this?

Thanks

Chris