I have the result of a query from ansible and I tried to use the result as
a variable
My playbook is like this
- name: Query
oracle_sql:
username: "{{ user }}"
password: "{{ password }}"
service_name: "{{ service_name }}"
sql: "select smth from table where smth like 'OK_%'"
register: smth"
the result is formatted as below
"msg": [
[
"SMTH"
]]
no stdout, no stderr
after this I want to use my variable
- name: echo
shell: echo {{ smth.msg[0] }} > /tmp/test
and the outuput is like this:
[uSMTH]
How to remove brackets and 'u' , I know it s a list but I can t get rid of
this
I tried to convert in yaml or json format no luck , this last add some
retrun carriage with
| to_yaml | to_json|to_nice_yaml| to_nice_json
Any advice ?
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/737ba56a-896f-4506-b297-7d84458594b7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
