Text to columns in access 2000

  • Thread starter Stupid and can prove it.
  • Start date
S

Stupid and can prove it.

My Access 2000 database contains a field name [ITEM]. Data in this field is
a varable number of characters to the left of an = sign and a variable number
of characters to the right of an = sign. I want to display only the
characters to the left of the = sign. I tried Split but apparently Access
2000 does not support that function. I need help.
 
P

pietlinden

Stupid said:
My Access 2000 database contains a field name [ITEM]. Data in this field is
a varable number of characters to the left of an = sign and a variable number
of characters to the right of an = sign. I want to display only the
characters to the left of the = sign. I tried Split but apparently Access
2000 does not support that function. I need help.
Click to expand...

use InStr to find the location of the first =, then use LEFT to get all
the characters to the left of that. Or you can use MID to start at
some other position than 1.
 
S

Stupid and can prove it.

YES, This worked. Now I'm not so Stupid. Thanks a bunch

KARL DEWEY said:
Try this --
Left([ITEM], InStr([ITEM],"=")-1)

Stupid and can prove it. said:
My Access 2000 database contains a field name [ITEM]. Data in this field is
a varable number of characters to the left of an = sign and a variable number
of characters to the right of an = sign. I want to display only the
characters to the left of the = sign. I tried Split but apparently Access
2000 does not support that function. I need help.
Click to expand...
Click to expand...
 
Top