Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mkinn
  • Order by date
  1. mkinn

    Remove non-numercial characters from a string

    There were a couple of things i had to change because of nulls and the message "A string can be at most 254 characters long". The formula i ended up with was: if not(isnull({myfield})) then (stringvar orig:={myfield}; numbervar looper; numbervar i:=len(orig); stringvar out :=...
  2. mkinn

    Remove non-numercial characters from a string

    I need to remove non-numerical characters from a string field so that i can convert the field to a number. The non-numeric characters could be anywhere in the string. I could write a lengthy formula using the replace function to remove non-numeric chars but is there a better way of doing this?

Part and Inventory Search

Back
Top