Skip to main content
D
DDhillon
Known Participant
June 30, 2006
Answered

Separate Comma delimited database field

  • June 30, 2006
  • 2 replies
  • 311 views
I have a ms access db field city with values like this:
Vancouver, BC V6A 4G8
Richmond, BC V6Y 1S6
Coquitlam, BC V3J 2W4

I would like to leave City names in city field like Vancouver, Richmond, Coquitlam goes in City. BC, BC, BC goes in field Province. V6A 4G8, V6Y 1S6, V3J 2W4 goes in PostalCode field. Is it possible?

Thank you
    This topic has been closed for replies.
    Correct answer
    Note that Vancouver, BC V6A 4G8 is a two element, comma-delimited list. Also note that BC V6A 4G8 is a three element space-delimigted list. So you can do something like the following:

    2 replies

    D
    DDhillonAuthor
    Known Participant
    June 30, 2006
    Thank you jdeline. It worked for me
    A
    Anonymous
    Correct answer
    June 30, 2006
    Note that Vancouver, BC V6A 4G8 is a two element, comma-delimited list. Also note that BC V6A 4G8 is a three element space-delimigted list. So you can do something like the following:
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices