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 don't 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"

 

I'd go with: ,(?!(?:.*,))

[mark007]

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

 

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

 

with

 

" and $2"

 

How does your's work Ingis? I can't 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 your's work Ingis? I can't say I follow it...

 

, the comma in question

(?! look ahead negative i.e. make sure this doesn't follow

(?: don't save this

.*, any number of charcters follwed by a comma

))