Lookup in a csv file with a multiple field key

[fanvalt]

Hello,

my csv file has the "," delimiter and is this way:

buddy,dv19,toto

eric,dv05,toto

buddy,dv05,toto

I can easily use the lookup command on a single key like buddy or eric or dv19 or dv05.

How could I proceed to select on a multiple key like "buddy,dv19" ? 

I tried to set a variable to buddy,dv1ç and use it this way, it cannot be found:

....

doublekey: buddy,dv19

....

 - debug: msg="the value of doublekey  is {{ lookup('csvfile', '{} file=/home/fanvalt/parameter_playbook/param.csv delimiter=, col=0'.format(doublekey)) }}"

any clue ?

Regards

[J Hawkesworth]

Not sure what the csvfile lookup plugin returns, but since you are inside {{ }} I'm guessing you can using jinja filters, so you might be able to use 'selectattr' to pick only those results which have the secondary key.

See the filters documentation here: http://jinja.pocoo.org/docs/dev/templates/#builtin-filters

Hope this helps

Jon

[fanvalt]

Thank you but lookup returns a field that is not the key in my case, I didn't find out how to use selectattr.

Because I cannot find out how to select on a multiple key, I tried to figure how to read all records from the file, beczuse lookup only select the 1st line found on the key value.

If I try to use the grep unix command, how to store the records in an array or by any way ?

Regards