how to split a column in MS Access

[Guest]

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

 

[Peter R. Fletcher]

On Fri, 8 Oct 2004 02:45:01 -0700, Ata Chaudhry <Ata

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

If you can't be bothered to check back on the newsgroup, why should we
be bothered to try to help you?

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[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.

 

[ophelie]

Hello,
I would like to use this function to split a column in 17 columns in Access. But I don't find the location of the command line. Where do I write my script in Access please ?