Regex help please

[Guest]

Hi
Can anyone help to write one regex to read all the fields in the following
comma delimited lines / file

some_alphanumer ic,some_alphanu meric,"somethin g,
something",some _hyhenated_numb ers
some_alphanumer ic,some_alphanu meric,something
something,some_ hyhenated_numbe rs

Please?!

TIA

--

[Guest]

Re: Regex help please

I can get most of the field with this
"[^"\r\n]*",|[A-Za-z0-9 ]*,|[0-9]*\-[0-9]*

EXCEPT when the last field (numbers) are not hyphenated, how do I an
optional "-" please!?

TIA

<dl> wrote in message news:ukmErNbZFH A.3364@TK2MSFTN GP09.phx.gbl...[color=blue]
> Hi
> Can anyone help to write one regex to read all the fields in the following
> comma delimited lines / file
>
> some_alphanumer ic,some_alphanu meric,"somethin g,
> something",some _hyhenated_numb ers
> some_alphanumer ic,some_alphanu meric,something
> something,some_ hyhenated_numbe rs
>
> Please?!
>
> TIA
>
> --
>
>
>[/color]