asked on 8/28/2013

how to replace the last comma in a comma separated list with ' and '

Hi

I am using vb.net 2005 and I'm not very familiar with regular expressions.

If i had a comma separated list of items in a string, how would i locate the last comma in the list and replace it with ' and '

for example

me, you becomes me and you
me, you, barbara becomes me, you and barbara

thanks a lot

Visual Basic.NET .NET Programming

Last Comment

andieje

8/28/2013

ASKER CERTIFIED SOLUTION

Robert Schutt

8/28/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Meir Rivkin

8/28/2013

        Dim str As String = "me, you, barbara"
        Dim index as integer = str.LastIndexOf(","c)
        str = str.Substring(0, index) & " and" & str.Substring(index + 1)

Open in new window

andieje

8/28/2013

ASKER

thanks!

.NET Programming

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

137K

Questions

Followers

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY