how to split a column in MS Access

[Ata Chaudhry]

I need to split a column in MS ACCESS, where In most rows of the column I
have a splitter as ":" Can someone please help and post the answer to my
Hotmail address:
(e-mail address removed)
thanks

 

[Douglas J. Steele]

Depending on exactly what you're trying to do, you can use InStr to
determine where the ":" occurs, then use the Left function to get everything
in front of the ":" or the Mid function to get everything after it:

Left([MyField], InStr([MyField], ":") - 1)
Mid([MyField], InStr([MyField], ":") + 1)

If you're using Access 2000 or newer, you can also use the Split function:

Split([MyField], ":")(0) will give you what's in front of the ":",
Split([MyField], ":")(1) will give you what's after it.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I need to split a column in MS ACCESS, where In most rows of the column I
have a splitter as ":" Can someone please help and post the answer to my
Hotmail address:
(e-mail address removed)
thanks

Sorry, that's not how newsgroups work. When you post your question in the
newsgroup, you come back to the newsgroup to get the answer.

 

[hermie]

I not see the split function in the built-in functions? I have access 2000?

Herman

Depending on exactly what you're trying to do, you can use InStr to
determine where the ":" occurs, then use the Left function to get everything
in front of the ":" or the Mid function to get everything after it:

Left([MyField], InStr([MyField], ":") - 1)
Mid([MyField], InStr([MyField], ":") + 1)

If you're using Access 2000 or newer, you can also use the Split function:

Split([MyField], ":")(0) will give you what's in front of the ":",
Split([MyField], ":")(1) will give you what's after it.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I need to split a column in MS ACCESS, where In most rows of the column I
have a splitter as ":" Can someone please help and post the answer to my
Hotmail address:
(e-mail address removed)
thanks

Sorry, that's not how newsgroups work. When you post your question in the
newsgroup, you come back to the newsgroup to get the answer.

 

[Douglas J. Steele]

Don't know where you're looking. Split was definitely introduced in Access
2000.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I not see the split function in the built-in functions? I have access 2000?

Herman

Depending on exactly what you're trying to do, you can use InStr to
determine where the ":" occurs, then use the Left function to get everything
in front of the ":" or the Mid function to get everything after it:

Left([MyField], InStr([MyField], ":") - 1)
Mid([MyField], InStr([MyField], ":") + 1)

If you're using Access 2000 or newer, you can also use the Split function:

Split([MyField], ":")(0) will give you what's in front of the ":",
Split([MyField], ":")(1) will give you what's after it.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I need to split a column in MS ACCESS, where In most rows of the

column

I

Sorry, that's not how newsgroups work. When you post your question in the
newsgroup, you come back to the newsgroup to get the answer.