Results 1 to 2 of 2
  1. #1
    swaroop1012 is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Nov 2008

    Split uneven text field

    HI all,

    I have two problems to discuss in this thread. I am working on Access 2002.

    the queries are:

    1. I had a address field with carriage returns in the middle. I used some code to remove the carriage returns and it worked fine. But the problem is som data has "," character at the end of the address text. Is there any way to remove the unwanted character at the end of the text.

    2. Also i want to seperate the street data from the address field.

    Stanion Road,Brigstock,Kettering,Northamptonshire,NN14 3HW,

    Bowling Green Recreation Ground,High Street,Islip,Northamptonshire,NN14 3JS

    1 Riverside Way,Islip,Kettering,Northamptonshire,NN14 3LF,

    In the above examples you can see the "," character at the end. I want to delete that.

    Also i want to seperate the terms like "stanion Road", "High street", "Riverside Way" etc. from the address field.

    Can anyone please help me in resolving these issues. Thanks in advance.


  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    See AWF for suggestion


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Finding highest value in a text field
    By cdominguez in forum Queries
    Replies: 3
    Last Post: 06-02-2009, 09:39 AM
  2. Split text field into two text fields
    By Grant in forum Access
    Replies: 6
    Last Post: 01-31-2008, 05:52 AM
  3. Quick way to stuff field names into text field
    By kfinpgh in forum Programming
    Replies: 0
    Last Post: 01-04-2007, 01:13 PM
  4. Replies: 1
    Last Post: 03-02-2006, 06:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums