Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2012
    Posts
    20

    Answered: Changing specific value wthin a feild

    Hello BD users,

    I have another simple question that I am trying to solve. I would like to change the word Street to ST within the address line field for all address lines for example from 123 Main Street to 123 Main ST. However, my script change entire field to ST. Is there away to ONLY change Street to ST but not the entire text?

    Thanks!
    Mohammed

  2. Best Answer
    Posted by Tubbritt

    "Hi Mohammed.
    Yeah sure no problem at all. Please see attached file.

    Regards
    James."


  3. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Hi Mohammed.
    Yeah sure no problem at all. Please see attached file.

    Regards
    James.
    Attached Files Attached Files

  4. #3
    Join Date
    Nov 2012
    Posts
    20
    Hi James,

    As always thank you very much for your help. I was able to accomplish the task with running few queries to apply it to all addresses. For some reason I wasn't able to use recordset with REPO format.

    Using query worked better for me for what I was trying to do.

    Thanks again for your help on this.

    Mohammed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •