Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: Remove certain digits from numbers

    10001465447710810001

    I want to remove the three 0s at the end and leave

    10001465447710811

    How can I do this?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try something like
    strmyfield= left$(strmyfield,len(strmyfield)-4) & right$(strmyfield,1)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2006
    Posts
    162
    Works perfect, thanks bro.

Posting Permissions

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