Comma as delimiter

  • Thread starter J Holtendehouzer
  • Start date
J

J Holtendehouzer

I have a listbox that I would like to hold short text items, some of which
contain commas. The problem is that the commas in the items are being
interpreted as delimiters. Is there a way to avoid this? I was hoping that
only semicolons would be delimiters.

My temporary solution was to change to an extended character that looks
similar to a comma, but that's clunky at best.

Thanks!
Joe
 
J

John Nurick

Hi Joe,

Enclose each item in quotes:

"Elephant, African"; "Elephant, Indian"
 
J

J Holtendehouzer

Thanks! That should have been obvious--I guess I just wasn't thinking it
through...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top