Need Help Creating an...

Results 1 to 2 of 2

Thread: Need Help Creating an...

  1. #1
    Join Date
    Dec 1969

    Default Need Help Creating an...

    Expression.<BR><BR>I have a variable that could look like two of the following examples when passed:<BR><BR>012345678-01 OR 01234567801<BR><BR>I need only one of the variables to be the correct one regardless of what is being passed. I must get rid of the "-" in the first example. How can I do this by using either a function or TRIM? <BR><BR>NOTE: <BR>1) The variable would always be either one of the above examples. But we can&#039;t predict that they may place the dash 4 or 5 places into the end of the number.<BR>2) Its always a number being passed.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Need Help Creating an...

    myVal = Replace(myVal, "-", "")

Posting Permissions

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