seperate field
 

I have the following field titled Path as part of a full query, that
has the following format of data, each row in the same format but different
text.

/Community & Government/Social & Human Services/Individual &
Family/Abuse/
Other rows in this field contain just

/Community & Government/Social & Human Services/

0r

/Community & Government

or
A/

I am looking to run the query so it returns only listings that contain the
four /../../../../ and then seperate the four into seperate fields.

seperate field
 

You could use the length of the field as a check:
=LEN(A1)

or the length without slashes:
=LEN(SUBSTITUTE(A1,"/",""))

or the number of slashes:
=LEN(A1) - LEN(SUBSTITUTE(A1,"/",""))

Use Data | Text to Columns to split the field up

Regards

Trevor


"Finger Tips" wrote in message
...
I have the following field titled Path as part of a full query, that
has the following format of data, each row in the same format but
different
text.

/Community & Government/Social & Human Services/Individual &
Family/Abuse/
Other rows in this field contain just

/Community & Government/Social & Human Services/

0r

/Community & Government

or
A/

I am looking to run the query so it returns only listings that contain
the
four /../../../../ and then seperate the four into seperate fields.

seperate field
 

Thanks Trevor. WHat do you mean by Use Data | Text to Columns to split the
field up. I would like the items between each / to be placed in 4 seperate
columns.


Shuttleworth" wrote:

You could use the length of the field as a check:
=LEN(A1)

or the length without slashes:
=LEN(SUBSTITUTE(A1,"/",""))

or the number of slashes:
=LEN(A1) - LEN(SUBSTITUTE(A1,"/",""))

Use Data | Text to Columns to split the field up

Regards

Trevor


"Finger Tips" wrote in message
...
I have the following field titled Path as part of a full query, that
has the following format of data, each row in the same format but
different
text.

/Community & Government/Social & Human Services/Individual &
Family/Abuse/
Other rows in this field contain just

/Community & Government/Social & Human Services/

0r

/Community & Government

or
A/

I am looking to run the query so it returns only listings that contain
the
four /../../../../ and then seperate the four into seperate fields.

seperate field
 

If you select the cells with data separated by slashes and then, from the
Menu bar select:

Data | Text to columns ... | Delimited by | Other | /

that's exactly what it will do ... split the field into separate cells. You
choose where.

Regards

Trevor


"Finger Tips" wrote in message
...
Thanks Trevor. WHat do you mean by Use Data | Text to Columns to split the
field up. I would like the items between each / to be placed in 4
seperate
columns.


Shuttleworth" wrote:

You could use the length of the field as a check:
=LEN(A1)

or the length without slashes:
=LEN(SUBSTITUTE(A1,"/",""))

or the number of slashes:
=LEN(A1) - LEN(SUBSTITUTE(A1,"/",""))

Use Data | Text to Columns to split the field up

Regards

Trevor


"Finger Tips" wrote in message
...
I have the following field titled Path as part of a full query, that
has the following format of data, each row in the same format but
different
text.

/Community & Government/Social & Human Services/Individual &
Family/Abuse/
Other rows in this field contain just

/Community & Government/Social & Human Services/

0r

/Community & Government

or
A/

I am looking to run the query so it returns only listings that contain
the
four /../../../../ and then seperate the four into seperate fields.