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.