Results 1 to 3 of 3

Thread: Striping Nulls From Strip

  1. Oct 13th, 2000, 05:46 PM #1
    Evan
    Evan is offline

    Thread Starter
    Frenzied Member
    Join Date
    Sep 1999
    Location
    Phoenix, az
    Posts
    1,517
    Can someone give me
    a function to strip nulls
    from a string?

    Thanks!
    [email protected]

    http://www.StockHawk.net Stock Blog
    http://www.warpedai.com Day Trading Software
    Reply With Quote Reply With Quote
  2. Oct 13th, 2000, 05:52 PM #2
    Iain17
    Iain17 is offline
    Fanatic Member
    Join Date
    Mar 2000
    Location
    That posh bit of England known as Buckinghamshire
    Posts
    658
    Use the replace function
    Code:
    strText = Replace(strText, vbNull, "")
    Iain, thats with an i by the way!
    Reply With Quote Reply With Quote
  3. Oct 13th, 2000, 05:57 PM #3
    Guest
    Code:
    Function StripNullChar(ByVal sIn As String) As String
    StripNullChar = Left(sIn, InStr(1, sIn, vbNullChar) - 1)
End Function
    Usage
    Code:
    MyString = StripNullChar(MyString)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width