Easy question (I think)

[kservice]

Hi all,

What would be the pattern for finding the last comma in a line of text?

Ex: Brown, Brown, Brown, Brown, Brown, Brown

Thanks a bunch!

 

[mark007]

You dont need a regex for this. Just use:

Dim s As String="Brown, Brown, Brown, Brown, Brown, Brown"
Dim pos as integer=s.LastIndexOf(",")

 

[kservice]

I was looking for a regular expression because I have to replace the last comma with the word "and".

I wanted to use a regular expression because I can find and replace with one line of code instead of several.

Thanks for your help.

 

[mark007]

Ah ok, how about:

"(,)([^,]*)$"

 

[IngisKahn]

That will give you ", Brown"

Id go with: ,(?!(?:.*,))

 

[mark007]

Well that was the point of the brackets i.e. you replace

"(,)([^,]*)$"

with

" and $2"

How does yours work Ingis? I cant say I follow it...

 

[kservice]

Thanks both of you. From what you gave me I got it to work exactly like I needed.

Thanks again.

 

[IngisKahn]

How does yours work Ingis? I cant say I follow it...

, the comma in question
(?! look ahead negative i.e. make sure this doesnt follow
(?: dont save this
.*, any number of charcters follwed by a comma
))