Ansible | How to construct a csv string from a dictionary

Question

I have a dictionary like this

customers:
  abc:
    id: 1
    status: active
  def:
    id: 2
    status: inactive
  ghi:
    id: 3
    status: active
  jkl:
    id: 4
    status: active

What's the best way to construct a string like below of the active customers only?

abc,ghi,jkl

Konstantin Suvorov · Accepted Answer · 2017-04-06 08:25:03Z

3

For example:

---
- hosts: localhost
  gather_facts: no
  vars:
    customers:
      abc:
        id: 1
        status: active
      def:
        id: 2
        status: inactive
      ghi:
        id: 3
        status: active
      jkl:
        id: 4
        status: active
  tasks:
    - debug:
        msg: "{{ customers | dictsort | selectattr('1.status','equalto','active') | map(attribute='0') | join(',') }}"

answered Apr 6, 2017 at 8:25

Konstantin Suvorov

68.9k9 gold badges175 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

GMaster Over a year ago

One more question, how can I also append a string (e.g. cust_) so the output looks like this? cust_abc,cust_ghi,cust_jkl

Konstantin Suvorov Over a year ago

Add map('regex_replace','^','cust_') before join

Timon de Groot · Accepted Answer · 2018-08-07 10:13:08Z

0

Not exactly what you asked for, but I think this might add value to the question.

In my case, I needed to join a list of items using a space.

defaults/main.yml

---
backup_dev_strip:
  - "@stripped"
  - "@development"

vars/main.yml

---
backup_dev_strip_merged: "{{ backup_dev_strip | join(' ') }}"

As a result

TASK [... : debug] 
ok: [...] => {
    "backup_dev_strip_merged": "@stripped @development"
}

answered Aug 7, 2018 at 10:13

Timon de Groot

8,4244 gold badges25 silver badges40 bronze badges

Collectives™ on Stack Overflow

Ansible | How to construct a csv string from a dictionary

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related