csvlookups referencing variables

Archives Ansible Project
1

Hello all,

I’m trying to do a csvlookup that references a variable so I can dynamically choose which line of the file. I tried the first two thinks to do the lookup with name only the third directly referencing the name works

  • hosts: “{{ target }}”
    vars:
    name : “REALUSER”
    uid : “{{ lookup(‘csvfile’, ''name delimiter=: file=/etc/passwd col=2 ') }}”
    gid : ‘{{ lookup(“csvfile”, name + “file=/etc/passwd col=3 delimiter=:”) }}’
    comment : ‘{{ lookup(“csvfile”, “REALUSER file=/etc/passwd delimiter=: col=4”) }}’
    tasks:
  • debug: msg=“The uid is {{ uid }} and the name is {{name}} and the gid is {{ gid }}”
2

the 2nd one is right, but you need a space:

'{{ lookup("csvfile", name + " file=/etc/passwd col=3 delimiter=:") }}'

3

If I do that I get back

[WARNING]: non fatal error while trying to template play variables: Failed to
template {{ lookup(“csvfile”, name + " file=/etc/passwd col=3 delimiter=:")
}}: csvfile: “delimiter” must be an 1-character string

4

Still can’t figure this out if anyone has any ideas.

Thanks,

Nick Wolff