Posted by Bosconian on 12/07/06 06:03

"Bosconian" <nobody@nowhere.com> wrote in message
news:nuWdncj_c-v-FerYnZ2dnUVZ_uqdnZ2d@comcast.com...
>I need a comma delimited regular expression pattern with the followng
>restrictions:
>
> no leading and trailing white space
> no trailing comma
> double quoted numeric/alpha pairs
> each pair on a separate line
>
> For example:
>
> "1","Peter"
> "2","Paul"
> "3","Mary"
>
> Any help is appreciated.
>
>

I've made a little progress since my last post. The pattern

^([0-9]\s?)+([,]\s?([A-Za-z0-9]\s?)+)*$

allows

1,Peter

and not

Peter,Paul

but will allow

1,Peter,Paul

I need to restrict the list to numeric,alpha pairs.

[Back to original message]