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).