I am trying to do a split function in Access. I have over 80,000 rows of data and one of the columns have part number such as XXXX-XXXXX-XXX and I want to split that column into 3 columns. I am told that there is a split function in access 2000 and above but I can't find it in my access .. is it an add in??? Lost in SPACE and office time.....a socket SET is more in my line.......
\/\/\//\//\//\//\//\/\//\/

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccess.htmGREAT site!!!! I found other stuff that I can use... but still doesn't answer my question about the split function. Does it exist and how do I get it?try the help file function........on the taskbar of access.....or goto msoft acesss website........not into office stuff......i prefer i outdoors......for working.....Yeahhhh I've looked ALL over. I ve GONE through the helps and even called Microsoft. Everyone keeps saying that there is a built in function in Access called split that will parse data by a delimiter. I just can't find it. I am getting pretty frustrated!!!! UGHHHHGHGHGHHGThere is also a Right Function in Help too


Left Function

Returns a Variant (String) containing a specified number of characters from the left side of a string.

Syntax

Left(string, length)

The Left function syntax has these named arguments:

Part Description
string Required. String expression from which the leftmost characters are returned. If string contains Null, Null is returned.
length Required; Variant (Long). Numeric expression indicating how many characters to return. If 0, a zero-length string ("") is returned. If greater than or equal to the number of characters in string, the entire string is returned.
Remarks

To determine the number of characters in string, use the Len function.

Note Use the LeftB function with byte data contained in a string. Instead of specifying the number of characters to return, length specifies the number of bytes.

example:
This example uses the Left function to return a specified number of characters from the left side of a string.

Dim AnyString, MyStr
AnyString = "Hello World" ' Define string.
MyStr = Left(AnyString, 1) ' Returns "H".
MyStr = Left(AnyString, 7) ' Returns "Hello W".
MyStr = Left(AnyString, 20) ' Returns "Hello World".
Between the Left, Right and Mid functions you should be able to slice and dice your field into as many "CHUNKS" of data as you are required.

Looking at your example, your query should include Left([partno],4), next field Mid([partno],6,5) assuming you don't want the dashes and a final field of Right([partno],3).

Hope this helps!

Ben