Text to columns in access 2000

[Guest]

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.

 

[Guest]

Try this --
Left([ITEM], InStr([ITEM],"=")-1)

 

[pietlinden]

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.

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.

 

[Guest]

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

Try this --
Left([ITEM], InStr([ITEM],"=")-1)

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.