On 4/3/19 11:35 AM, [email protected] wrote: > 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:Queryoracle_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 ?
Using smth[0][0] should do the trick (first field in the first sql record).
Regards
Racke
>
> --
> 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]
> <mailto:[email protected]>.
> To post to this group, send email to [email protected]
> <mailto:[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
> <https://groups.google.com/d/msgid/ansible-project/737ba56a-896f-4506-b297-7d84458594b7%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.
--
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/00407cd6-33b6-9b4f-0779-ad22c877e524%40linuxia.de.
For more options, visit https://groups.google.com/d/optout.
signature.asc
Description: OpenPGP digital signature
