I'm in need of modifying certain values within JSON data and integrating it into an existing shell script. My aim is to utilize jq for this task, specifically the "sub()" function to trim a portion of a string value.
Executing the following command line:
jq '._meta[][].ansible_ssh_pass | sub(" .*" ; "")'
using the given data will successfully update the value (removing everything after the first space in the data) but only displays the altered value without the complete JSON structure.
Here is an example of the JSON dataset:
{
"_meta": {
"hostvars": {
"10.1.1.3": {
"hostname": "core-gw1",
"ansible_user": "",
"ansible_ssh_pass": "test123 / ena: test2",
"configsicherung": "true",
"os": "ios",
"managementpaket": ""
}
}
}
}
The expected output should resemble the following:
{
"_meta": {
"hostvars": {
"10.1.1.3": {
"hostname": "core-gw1",
"ansible_user": "",
"ansible_ssh_pass": "test123",
"configsicherung": "true",
"os": "ios",
"managementpaket": ""
}
}
}
}
I presume that I need to incorporate some form of "if... then" logic, however, communicating effectively with jq has proven challenging. The manual lacks clarity, and finding a relevant example matching my requirements has been fruitless...