seperate field

[Finger Tips]

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.

 

[Trevor Shuttleworth]

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]

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.

 

[Trevor Shuttleworth]

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