How to perform an opposite of CONCATENATE ON A table

[stevlory]

hi
I have a field like "123 || 569" and I would like to keep only the first numbers(123).
Thanks for your help,
lori

[FishVal]

hi
I have a field like "123 || 569" and I would like to keep only the first numbers(123).
Thanks for your help,
lori

Hi!

There are several options here.

• the length of substring is constant (3 in the example above)

  Left(strYourString,3)

  will return first 3 characters of a string
• you want to cut substring from the left to predefined separator ("||" in the example above)

  Trim(Left(strYourString, InStr(1,strYouString,"||")-1))

  will return substring from the left to "||" trimming unnecessary spaces

[NeoPa]

Another interesting option, assuming the string holds number strings separated by a character ("|" in this case), is to use Split()

YourVariable = Split([Field],"|")(0)

Unfortunately, this is limited to running in code (VBA) and will be useless in a query or in SQL code :(