How to filter data through awk or grep to get the time only?

hariraj

1/17/23, 7:02 AM

curl -H Metadata:true --noproxy "*" "http://169.254.169.254/metadata/instance/compute/tagsList? 
api-version=2019-06-04"|

Through the above command I'm getting out put like below

root@puppetagent-ubuntu1:/home/azureuser# grep -i "shutdown_time" test.txt  |awk '/value/{print}' |jq

[ { "name": "Application_Name", "value": "POC-Exception" }, { "name": "Cost_Center", "value": "1000501541" }, { "name": "Stage", "value": "POC" }, { "name": "shutdown_time", "value": "16:00 [IST]" } ]

So I want to filter where time and time zones are like IST or PST in value but in this where time is not fixed and time zone is not fixed. Please help me.

0 + 0

command-line

text-processing

json

pLumo

1/17/23, 7:05 AM

Please provide us the expected output. Your english is a bit difficult to understand, maybe you can try to fix it a bit, so we can understand correctly.

hariraj

1/17/23, 7:45 AM

Expected output is "16:00" for now but the value will be changing based on system tag.

Score:2

Ubuntu

pLumo

1/17/23, 9:28 AM

Use jq:

$ ... | jq -r '.[]|select(.name == "shutdown_time").value'
16:00 [IST]

$ ... | jq -r '.[]|select(.name == "shutdown_time").value' | cut -d' ' -f1
16:00

0 + 0

hariraj

1/17/23, 11:17 AM

How to remove square bracket through the "cut" command if the input is [16:00]?

pLumo

1/17/23, 11:19 AM

you don't use the `cut` for it, rahter `sed` or `awk` then.

steeldriver

1/17/23, 11:29 AM

... you could also consider additional filtering inside jq ex. `|split(" ")[0]` in the first case or `|sub("[][]";"";"g")` for the remove brackets case

hariraj

1/17/23, 2:08 PM

Thanks a lot Mr pLumo & Steeldriver for the help above .

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: How to filter data through awk or grep to get the time only?

TH: จะกรองข้อมูลผ่าน awk หรือ grep เพื่อรับเวลาเท่านั้นได้อย่างไร

RO: Cum se filtrează datele prin awk sau grep pentru a obține doar timpul?

RU: Как отфильтровать данные через awk или grep, чтобы получить только время?

VI: Làm cách nào để lọc dữ liệu qua awk hoặc grep để chỉ lấy thời gian?

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.