Remove strings before certain character batch/python

Question

How can I remove letters before certain character? I need to remove every letter from following string until “[“ character and redirect output to .csv file.

{"__metadata": {"uri": loremipsum etc [ {rest of the document}

Answer 1

Find the position of '[' and get the string after that position

print s[s.find("[")+1:].strip()

Sample output:

{rest of the document}

Hope it helps!

Answer 2

You can split from the first occurence and take the rest like :

>>> string = "Egg[spam:miam"
>>> string.split("[", 1)[1]
>>> spam:miam

OR

>>> string = "Egg[spam:miam"
>>> string[string.index("[") + 1:]
>>> spam:miam

Answer 3

As per your provided info and required fields, i will suggest that if your JSON data is in a file then you can use:

import json
data = {}
with open("path to json file") as f:
    data = json.loads(f.read())

or if your data is stored in string then you can simply do

data = json.loads("json data string")

now you have data in a python dictionary object. now you can easily get any field from the object e.g getting field "cuid" from the first object in entries list:

print data["entries"][0]["cuid"]

or alternatively you can loop on entries list and get all the fields you need e.g

for entry in data["entries"]:
    print entry["cuid"]
    print entry["name"]
    print entry["id"]
    print entry["type"]