Remove non-numeric characters

Results 1 to 2 of 2

Thread: Remove non-numeric characters

  1. #1
    Join Date
    Dec 1969

    Default Remove non-numeric characters

    I have a field which users are going to type an integer into.<BR>This field is not required.<BR><BR>If a user types in 10,000 instead of throwing a javascript<BR>error, saying fix this before continuing, I would like my<BR>code to just remove all non-numeric characters.<BR><BR>I want to insert 10000 into my db for ease of number manipulation<BR>rather than making a varchar field that allows 10,000<BR><BR>What is the best was to accomplish this?<BR><BR>Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Remove non-numeric characters

    nonvalidchars= "," & "-" & so on....<BR>use the replace function to replace invalid with ""

Posting Permissions

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