jq replace part of value in json

json sed edit jq iso8601
Ryan Loeffler picture Ryan Loeffler · Mar 8, 2018 · Viewed 7.3k times · Source

I need to replace part of a value from a json output and i could easily do this using sed -i however it would also replace other parts of the file i dont want it to, unless im missing something. The out put is { "LastModified": "2018-03-07T17:24:33.000Z", "Key": "pending/archive/f7ab1684-e94d-483e-ace1-560367c1196c_1000_s.json" }

and I need to replace the dash "-" on the LastModified value to a slash, then remove some stuff too like the "T" and the ".000Z" So i can eventually convert that timestamp to epoch.

I tried using cat list | jq -r '.[] | select (.LastModified == "-") .LastModified = "/"' and |= operator but i cant find anywhere else on the web that this has been accomplished.

Answer

RomanPerekhrest picture RomanPerekhrest · Mar 8, 2018

With jq's sub() and fromdate() functions:

jq '.LastModified |= (sub("\\.000Z";"Z") | fromdate)' input.json

The output:

{
  "LastModified": 1520443473,
  "Key": "pending/archive/f7ab1684-e94d-483e-ace1-560367c1196c_1000_s.json"
}

Related questions

Use jq to parse a JSON String

I'm trying to get jq to parse a JSON structure like: { "a" : 1, "b" : 2, "c" : "{\"id\":\"9ee ...\",\"parent\":\"abc...\"}\n" } That is, an element in the JSON is a string with escaped json. So, I have something along the lines of $ …

Read More
How do I POST JSON data with cURL?

I use Ubuntu and installed cURL on it. I want to test my Spring REST application with cURL. I wrote my POST code at the Java side. However, I want to test it with cURL. I am trying to post …

Read More
What is the correct JSON content type?

I've been messing around with JSON for some time, just pushing it out as text and it hasn't hurt anybody (that I know of), but I'd like to start doing things properly. I have seen so many purported "standards" for …

Read More