JQ command to retrieve just the titles

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












I have this json file:



"["id":188457,"title":"Painted Dragon Tea Mug with Lid","slug":"painted-dragon-tea-mug-with-lid","image":"https:\/\/thievemedia.imgix.net\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","full_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","large_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","medium_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","original_price":"19.78","price":"13.65","discount":"30.99","rating":"4.7","total_orders":"10","promotion_url":"https:\/\/api.thieve.co\/view?id=MzI4NTk0Njg0MDE=","product_like_count":"100","product_user_likes"]


How can I extract only the titles with jq?






jq







share|improve this question























  • That's not valid JSON -- it is a JS string containing escape sequences, so you'll first have to remove those escapes with eg. sed 's/^"//;s/"$//;s/\(.)/1/g'
    – JigglyNaga
    7 hours ago










  • Thank you! It worked!
    – Kerim Güleç
    6 hours ago














up vote
0
down vote

favorite












I have this json file:



"["id":188457,"title":"Painted Dragon Tea Mug with Lid","slug":"painted-dragon-tea-mug-with-lid","image":"https:\/\/thievemedia.imgix.net\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","full_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","large_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","medium_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","original_price":"19.78","price":"13.65","discount":"30.99","rating":"4.7","total_orders":"10","promotion_url":"https:\/\/api.thieve.co\/view?id=MzI4NTk0Njg0MDE=","product_like_count":"100","product_user_likes"]


How can I extract only the titles with jq?






jq







share|improve this question























  • That's not valid JSON -- it is a JS string containing escape sequences, so you'll first have to remove those escapes with eg. sed 's/^"//;s/"$//;s/\(.)/1/g'
    – JigglyNaga
    7 hours ago










  • Thank you! It worked!
    – Kerim Güleç
    6 hours ago












up vote
0
down vote

favorite









up vote
0
down vote

favorite











I have this json file:



"["id":188457,"title":"Painted Dragon Tea Mug with Lid","slug":"painted-dragon-tea-mug-with-lid","image":"https:\/\/thievemedia.imgix.net\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","full_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","large_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","medium_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","original_price":"19.78","price":"13.65","discount":"30.99","rating":"4.7","total_orders":"10","promotion_url":"https:\/\/api.thieve.co\/view?id=MzI4NTk0Njg0MDE=","product_like_count":"100","product_user_likes"]


How can I extract only the titles with jq?






jq







share|improve this question















I have this json file:



"["id":188457,"title":"Painted Dragon Tea Mug with Lid","slug":"painted-dragon-tea-mug-with-lid","image":"https:\/\/thievemedia.imgix.net\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","full_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","large_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","medium_image_url":"https:\/\/s3.amazonaws.com\/thieve-media\/wp-content\/uploads\/2018\/09\/painted-dragon-tea-mug-with-lid-featured-1.jpg","original_price":"19.78","price":"13.65","discount":"30.99","rating":"4.7","total_orders":"10","promotion_url":"https:\/\/api.thieve.co\/view?id=MzI4NTk0Njg0MDE=","product_like_count":"100","product_user_likes"]


How can I extract only the titles with jq?






jq




jq






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 8 hours ago









Jeff Schaller

33.8k851113




33.8k851113










asked 9 hours ago









Kerim Güleç

61




61











  • That's not valid JSON -- it is a JS string containing escape sequences, so you'll first have to remove those escapes with eg. sed 's/^"//;s/"$//;s/\(.)/1/g'
    – JigglyNaga
    7 hours ago










  • Thank you! It worked!
    – Kerim Güleç
    6 hours ago
















  • That's not valid JSON -- it is a JS string containing escape sequences, so you'll first have to remove those escapes with eg. sed 's/^"//;s/"$//;s/\(.)/1/g'
    – JigglyNaga
    7 hours ago










  • Thank you! It worked!
    – Kerim Güleç
    6 hours ago















That's not valid JSON -- it is a JS string containing escape sequences, so you'll first have to remove those escapes with eg. sed 's/^"//;s/"$//;s/\(.)/1/g'
– JigglyNaga
7 hours ago




That's not valid JSON -- it is a JS string containing escape sequences, so you'll first have to remove those escapes with eg. sed 's/^"//;s/"$//;s/\(.)/1/g'
– JigglyNaga
7 hours ago












Thank you! It worked!
– Kerim Güleç
6 hours ago




Thank you! It worked!
– Kerim Güleç
6 hours ago










1 Answer
1






active

oldest

votes

















up vote
2
down vote













The query '. | title' will give you just the title elements (but note that your sample document seems to be malformed), assuming your document is in a file called data.json:



$ jq '. | title' data.json

 "title": "Painted Dragon Tea Mug with Lid"



The first part of the query, '.', returns each object in the top-level array, and these are then sent to the second part, using the | operator. The second part of the query, title, simply extracts the "title" element from the object.



If you want just the title, as a string, without wrapping the results in a JSON object, use this instead:



$ jq '. | .["title"]' data.json
"Painted Dragon Tea Mug with Lid"


The jq tutorial offers a good overview of the query language.






share|improve this answer




















  • Thank you for your reply. The original file is at api.thieve.co/wp-json/thieve/v1/products/?category-name=/… but I'm getting an error :(
    – Kerim Güleç
    7 hours ago











  • You can shorten the expression to ..title.
    – JigglyNaga
    7 hours ago










Your Answer







StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f474295%2fjq-command-to-retrieve-just-the-titles%23new-answer', 'question_page');

);

Post as a guest

















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
2
down vote













The query '. | title' will give you just the title elements (but note that your sample document seems to be malformed), assuming your document is in a file called data.json:



$ jq '. | title' data.json

 "title": "Painted Dragon Tea Mug with Lid"



The first part of the query, '.', returns each object in the top-level array, and these are then sent to the second part, using the | operator. The second part of the query, title, simply extracts the "title" element from the object.



If you want just the title, as a string, without wrapping the results in a JSON object, use this instead:



$ jq '. | .["title"]' data.json
"Painted Dragon Tea Mug with Lid"


The jq tutorial offers a good overview of the query language.






share|improve this answer




















  • Thank you for your reply. The original file is at api.thieve.co/wp-json/thieve/v1/products/?category-name=/… but I'm getting an error :(
    – Kerim Güleç
    7 hours ago











  • You can shorten the expression to ..title.
    – JigglyNaga
    7 hours ago














up vote
2
down vote













The query '. | title' will give you just the title elements (but note that your sample document seems to be malformed), assuming your document is in a file called data.json:



$ jq '. | title' data.json

 "title": "Painted Dragon Tea Mug with Lid"



The first part of the query, '.', returns each object in the top-level array, and these are then sent to the second part, using the | operator. The second part of the query, title, simply extracts the "title" element from the object.



If you want just the title, as a string, without wrapping the results in a JSON object, use this instead:



$ jq '. | .["title"]' data.json
"Painted Dragon Tea Mug with Lid"


The jq tutorial offers a good overview of the query language.






share|improve this answer




















  • Thank you for your reply. The original file is at api.thieve.co/wp-json/thieve/v1/products/?category-name=/… but I'm getting an error :(
    – Kerim Güleç
    7 hours ago











  • You can shorten the expression to ..title.
    – JigglyNaga
    7 hours ago












up vote
2
down vote










up vote
2
down vote









The query '. | title' will give you just the title elements (but note that your sample document seems to be malformed), assuming your document is in a file called data.json:



$ jq '. | title' data.json

 "title": "Painted Dragon Tea Mug with Lid"



The first part of the query, '.', returns each object in the top-level array, and these are then sent to the second part, using the | operator. The second part of the query, title, simply extracts the "title" element from the object.



If you want just the title, as a string, without wrapping the results in a JSON object, use this instead:



$ jq '. | .["title"]' data.json
"Painted Dragon Tea Mug with Lid"


The jq tutorial offers a good overview of the query language.






share|improve this answer












The query '. | title' will give you just the title elements (but note that your sample document seems to be malformed), assuming your document is in a file called data.json:



$ jq '. | title' data.json

 "title": "Painted Dragon Tea Mug with Lid"



The first part of the query, '.', returns each object in the top-level array, and these are then sent to the second part, using the | operator. The second part of the query, title, simply extracts the "title" element from the object.



If you want just the title, as a string, without wrapping the results in a JSON object, use this instead:



$ jq '. | .["title"]' data.json
"Painted Dragon Tea Mug with Lid"


The jq tutorial offers a good overview of the query language.







share|improve this answer












share|improve this answer



share|improve this answer










answered 7 hours ago









D_Bye

10.2k13026




10.2k13026











  • Thank you for your reply. The original file is at api.thieve.co/wp-json/thieve/v1/products/?category-name=/… but I'm getting an error :(
    – Kerim Güleç
    7 hours ago











  • You can shorten the expression to ..title.
    – JigglyNaga
    7 hours ago
















  • Thank you for your reply. The original file is at api.thieve.co/wp-json/thieve/v1/products/?category-name=/… but I'm getting an error :(
    – Kerim Güleç
    7 hours ago











  • You can shorten the expression to ..title.
    – JigglyNaga
    7 hours ago















Thank you for your reply. The original file is at api.thieve.co/wp-json/thieve/v1/products/?category-name=/… but I'm getting an error :(
– Kerim Güleç
7 hours ago





Thank you for your reply. The original file is at api.thieve.co/wp-json/thieve/v1/products/?category-name=/… but I'm getting an error :(
– Kerim Güleç
7 hours ago













You can shorten the expression to ..title.
– JigglyNaga
7 hours ago




You can shorten the expression to ..title.
– JigglyNaga
7 hours ago

















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f474295%2fjq-command-to-retrieve-just-the-titles%23new-answer', 'question_page');

);

Post as a guest
































































-

Popular posts from this blog

How to check contact read email or not when send email to Individual?

Image
Clash Royale CLAN TAG #URR8PPP up vote 1 down vote favorite I'm using WordPress 4.9.8, CiviCRM to 5.5.1, I usually send email to contact by Search> Find contacts View contact details Action> Send email Send email ok, Contact received mail ok like picture But status only Email sent though contact read email or not. So, can CiviCRM can change status to Email read when contact read email? wordpress email share | improve this question asked Sep 26 at 0:12 ToanLuong 49 9 add a comment  |  up vote 1 down vote favorite I'm using WordPress 4.9.8, CiviCRM to 5.5.1, I usually send email to contact by Search> Find contacts View contact details Action> Send email Send email ok, Contact received mail ok like picture But status only Email sent though contact read email or not. So, can CiviCRM can change status to Email read when contact read email? wordpress email share | improve this questi...
Read more

Christian Cage

Image
Christian Cage Christian in March 2015 Birth name William Jason Reso Born ( 1973-11-30 ) November 30, 1973 (age 45) Kitchener, Ontario, Canada Residence Tampa, Florida, United States Spouse(s) Denise Hartmann ( m.   2001 ) Children 1 Professional wrestling career Ring name(s) Christian [1] Christian Cage [2] Conquistador Dos [3] Male Nurse [4] Billed height 6 ft 1 in (1.85 m) [1] Billed weight 212 lb (96 kg) [1] Billed from Tampa, Florida (WM18, TNA) Toronto, Ontario, Canada [1] Trained by Dory Funk Jr. [2] Ron Hutchison [5] Debut 1995 [5] Retired 2014 [6] William Jason Reso (born November 30, 1973) is a Canadian actor, podcaster and retired professional wrestler best known for his time in WWE under the ring name Christian , a shortened version of his original ring name Christian Cage that was also used during his tenure in Total Nonstop Action Wrestling (TNA). Reso was trained by former professional wrestlers Ron Hutchison and Dory Funk Jr. and m...
Read more

How to properly install USB display driver for Fresco Logic FL2000DX on Ubuntu?

Image
Clash Royale CLAN TAG #URR8PPP up vote 4 down vote favorite 1 I need to connect additional monitors on my computer and I get Fresco Logic FL2000DX USB display adapters. This adapters works perfect on Windows but I need to use on my development machine based on Ubuntu 16.04. I find this on git hub: https://github.com/fresco-fl2000/fl2000 and try to install it but installation fail. Can anyone help me regarding this? Thanks! ubuntu drivers display-settings proprietary-drivers share | improve this question asked Aug 16 '17 at 16:42 Ivijan Stefan Stipić 142 1 6 add a comment  |  up vote 4 down vote favorite 1 I need to connect additional monitors on my computer and I get Fresco Logic FL2000DX USB display adapters. This adapters works perfect on Windows but I need to use on my development machine based on Ubuntu 16.04. I find this on git hub: https://github.com/fresco-fl2000/fl2000 and ...
Read more