how to grep the word within the {...} using python

Question

i would like to grep the only value: "INC1301724" from the "display_value":"INC1301724", from the text file: Response.txt below:

print('Response after Snow ticket update : '+response.text)

value of response.text is:

{"import_set":"ISET1677878","staging_table":"u_incident_create_import","result":[{"transform_map":"Incident Create Import","table":"incident","display_name":"number","display_value":"INC1301724","record_link":"https://example.com/api/now/table/incident/04331234rfgthyjjkkkkllljhfdd","status":"inserted","sys_id":"01234567890"}]}

You mean you're executing the python script and piping it to grep? — Barmar, Jun 02 '23 at 01:01
`response.text` looks like JSON. So remove `Response after Snow ticket update :` from the beginning, then use `jq` to parse it rather than `grep`. — Barmar, Jun 02 '23 at 01:02
[How can I access the nested data in this complex JSON, which includes another JSON document as one of the strings?](https://stackoverflow.com/q/48193502) — SuperStormer, Jun 02 '23 at 01:24
What is `response`? Is it the return value of a `requests.get` call? Post your whole code. — Selcuk, Jun 02 '23 at 01:27
why not just `response.json()["result"][0]["display_value"]`? — KamilCuk, Jun 03 '23 at 22:06

Hasan · Answer 1 · 2023-06-02T13:24:11.560

you just need to search every line for "display_value" then cut the substring with search about index of '"' : this is image of the Solution

with open('response.txt') as file:
for line in file:
    String_Line=line.rstrip()
    if "display_value" in String_Line:
        index1 = String_Line.find ( 'display_value":' )
        Newstring=String_Line[index1+16:]
        print(Newstring)
        new_index_1 = Newstring.find('"')
        print(new_index_1)
        your_string=Newstring[:new_index_1]
        print(your_string)

score 0 · Answer 2 · answered Jun 03 '23 at 22:02

Use json:

json.loads('{"import_set":"ISET1677878","staging_table":"u_incident_create_import","result":[{"transform_map":"Incident Create Import","table":"incident","display_name":"number","display_value":"INC1301724","record_link":"https://example.com/api/now/table/incident/04331234rfgthyjjkkkkllljhfdd","status":"inserted","sys_id":"01234567890"}]}')["result"][0]["display_value"]

how to grep the word within the {...} using python

2 Answers2