Use a CSV cell value as a regex string using re in Python

Question

So I have a CSV document that has metadata, an XPATH and a Regex String in each row. The script uses the xpath to iterate over API requests and then I want to use the regex stored in the CSV with that xpath to search for something in the API results. My issue is how to use the data in a CSV row as a literal regex search string, like r'^\w{2}.+' versus a string to search against.

with open(rules, 'r+') as rulefile:
    rreader = csv.DictReader(rulefile)
    for row in rreader:
        for ip, apikey in keydict.iteritems():
            rulequery = {'type': 'config', 'action': 'get', 'key': apikey, 'xpath': row["xpath"]}
            rrule = requests.get('https://' + ip + '/api', params = rulequery, verify=False)
            rrex = re.compile('{}'.format(row["regex"]), re.MULTILINE)
            for line in rrule.text:
                config = rrex.findall(line)
                print(config)

What is the issue ? It doesn't work ? Do you get an error ?

Spirine
– Spirine

2015-05-11 18:51:23 +00:00
Commented May 11, 2015 at 18:51 — Spirine
– Spirine, Commented May 11, 2015 at 18:51
No it just returns... [] [] [] [] [] [] [] [] [] []

Jessica Ferguson
– Jessica Ferguson

2015-05-11 19:18:06 +00:00
Commented May 11, 2015 at 19:18 — Jessica Ferguson
– Jessica Ferguson, Commented May 11, 2015 at 19:18

Jessica Ferguson · Accepted Answer · 2015-05-11 20:20:31Z

1

So I think I may have found a solution, although Im not sure it is the best... Open for assistance if anyone has a better way to do it.

with open(rules, 'r+') as rulefile:
rreader = csv.DictReader(rulefile)
for row in rreader:
    for ip, apikey in keydict.iteritems():
        regex = row["regex"]
        rulequery = {'type': 'config', 'action': 'get', 'key': apikey, 'xpath': row["xpath"]}
        rrule = requests.get('https://' + ip + '/api', params = rulequery, verify=False)
        config = re.search(regex, rrule.text)
        print rrule.text[config.start():config.end()]

answered May 11, 2015 at 20:20

Jessica Ferguson

1091 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use a CSV cell value as a regex string using re in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related