Hi Oscar,

the StringContainsQ is only there because the search string contains spaces etc. If you take the exact search string and "double equal" it to #[[7]] it should work, too. If you had MMA10 the StringContainsQ function is slightly better, becaus it gives the result you want and also caters for cases where spaces etc are not always entered in the same way.

Cheers, Matco

Thanks Marco,

Unfortunately StringContainsQ is only available in Mathe 10, but i only have acces to version 9

Thank you

What about

Part[Select[data, (#[[1]] == "1 VTS" && StringContainsQ[#[[7]], "Female"]) &], All]

Cheers,

Marco

Select can be used outside of query, and was available much earlier.

In[1]:= Vts = {{"1 VTS", 2., 2., 5., 2., 5., "Female"}, {"1 VTS", 2., 
    2., 5., 2., 5., "Male"}, {"1 VTS", 2., 2., 5., 2., 5., "Female"}};

In[2]:= Select[Vts, #[[7]] == "Female" &]

Out[2]= {{"1 VTS", 2., 2., 5., 2., 5., "Female"}, {"1 VTS", 2., 2., 
  5., 2., 5., "Female"}}

In[3]:= (* Note:  #[[7]]\[Equal]"Female"& is a "pure function" *)

Hello Emmerson,

I tried what you show me, but i did not work, then i realise that Query is an option only in mathematica 10 and for now i have access to mathematica 9. There is a similar option in mathematica 9?

I'll add the excel file and the notebook, probably it will help

Thank you

Attachments:

deleted..