Need help with strings...

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Josh,

Try Serial:left([YourField],instr([YourField]," ")-1)

That should find the space, and trim off anything after
it.

Mark
-----Original Message-----
I have a list of numbers, but some of them are
Click to expand...
followed by a space then a parenthesis and then sometimes
letters. I just want to keep my first number, which is a
serial number for a part. This serial number sometimes
includes a letter, which is fine. Here are a few from my
list:
 
You might have to do Mark's idea a few more times, inside of a few IIF's. That way you can check for spaces, then a letter, then a parentheses
I do not know the function that can check if a character is a number or letter, but that would also help your query
Ti

----- Mark wrote: ----

Josh

Try Serial:left([YourField],instr([YourField]," ")-1

That should find the space, and trim off anything after
it

Mar
-----Original Message----
I have a list of numbers, but some of them are
Click to expand...
followed by a space then a parenthesis and then sometimes
letters. I just want to keep my first number, which is a
serial number for a part. This serial number sometimes
includes a letter, which is fine. Here are a few from my
list
 
Back
Top