Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Question Unanswered: replace string value with other string value

    A text field contains text.
    I want to find the first "\" in the string and remove it.
    how do I do this?

    thanks in advance
    ActionAnt

  2. #2
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    Theres probably a better way but heres a solution to get you by until then:


    Dim The_String As String
    Dim Find_Where_It_IS As Integer

    The_String = "this is a string with a \ in it"

    Find_Where_It_IS = InStr(1, The_String, "\")

    Debug.Print Left(The_String, Find_Where_It_IS - 1) & Right(The_String, Len(The_String) - Find_Where_It_IS - 1)



    Hope it helps.

    Ken


Posting Permissions

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