如何使用正则表达式从cloudwatchloginsights查询的输出中过滤？

Question

我是python新手

下面是我在cloudwatchinsights查询中的输出

{'results': [[{'field': '@m', 'value': 'upload  `onetest.csv`'}, {'field': '@ptr', 'value': 'CmkKMAosMDI2uwxIuRlQtBQQAhgB'}], [{'field': '@m', 'value': 'upload `onecube.csv`'}, {'field': '@ptr', 'value': 'CmkKMAosMDI2NzYzlQuxQQAhgB'}], [{'field': '@m', 'value': 'upload  `onetra.csv`'}, {'field': '@ptr', 'value': 'CmkKMAosyhRIghxQ/BYQBhgB'}], [{'field': '@m', 'value': 'upload  `onecant.csv`'}], 'statistics': {'recordsMatched': 79.0, 'recordsScanned': 550.0, 'bytesScanned': 147117.0}, 'status': 'Complete', 'ResponseMetadata': {'RequestId': '7c79a28597ca', 'HTTPStatusCode': 200, 'HTTPHeaders': {'x-amzn-requestid': '7c7d498a9a28597ca', 'content-type': 'application/x-amz-json-1.1', 'content-length': '20282', 'date': 'Tue, 17:17:11 GMT'}, 'RetryAttempts': 0}}

我想使用python解析输出，如下所示

1. onetest.csv.
2. onecube.csv
3.onetra.csv
4.onecant.csv

我尝试使用re模块使用正则表达式，但我可以得到精确的输出

Answer 1

这样试试。

cloudwatchinsights = [[{'field': '@m', 'value': 'upload  `onecube.csv`'}, {'field': '@ptr', 'value': 'CmoKMDAYAQ=='}], [{'field': '@m', 'value': 'upload  `onetra.csv`'}, {'field': '@ptr', 'value': 'CmoKMAI5JECoYAQ=='}]]

result = [ each[0]['value'][9:-1] for each in cloudwatchinsights ]

输出：

['onecube.csv', 'onetra.csv']