it works thanks a lot can you explain to me please about the [0][0] thanks in advance
Le mer. 3 avr. 2019 à 11:42, Stefan Hornburg (Racke) <[email protected]> a écrit : > 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. > -- 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/CADC4zwwApAufpzEeDgnSA%2B72enXytqs_ToYBDLccVkK6im%2B2yg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
