Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Removing specific characters from a text field

Discussion in 'Information Technology' started by LMIU, Nov 5, 2005.

  1. LMIU

    LMIU
    Expand Collapse
    Guest

    I have a text field of vessel names which need cleaning as some are in the
    format "** Vessel Name" or "* Vessel Name". I want to remove the "*"
    characters from the field, after which I plan to use the trim function within
    a second update query.

    I understand that i'd be able to use something like (Replace([Name]"*",""")
    to remove them if I was using a later version of Access, but unfortunately my
    version is 97 so it doesn't work.

    I was trying to use a function containing the ASCII code for the * character
    - chr(44), but am unsure how to do this as I couldn't find a specific delete
    function.

    Any help much appreciated.
     
  2. Loading...


  3. Roger Carlson

    Roger Carlson
    Expand Collapse
    Guest

    On my website (www.rogersaccesslibrary.com), is a small Access database
    sample called "StringStuff.mdb" which has a ReplaceCharacter and
    ReplaceString function. There is an Access 97 version available.

    --
    --Roger Carlson
    Access Database Samples: www.rogersaccesslibrary.com
    Want answers to your Access questions in your Email?
    Free subscription:
    http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


    "LMIU" <LMIU@discussions.microsoft.com> wrote in message
    news:F8B9AF93-3128-42A9-B3E0-8C280E46BCF9@microsoft.com...
    > I have a text field of vessel names which need cleaning as some are in the
    > format "** Vessel Name" or "* Vessel Name". I want to remove the "*"
    > characters from the field, after which I plan to use the trim function

    within
    > a second update query.
    >
    > I understand that i'd be able to use something like

    (Replace([Name]"*",""")
    > to remove them if I was using a later version of Access, but unfortunately

    my
    > version is 97 so it doesn't work.
    >
    > I was trying to use a function containing the ASCII code for the *

    character
    > - chr(44), but am unsure how to do this as I couldn't find a specific

    delete
    > function.
    >
    > Any help much appreciated.
     

Share This Page