shell html table转csv,使用shell或批处理命令lin将Python Pretty table转换为CSV

这是一个非常丑陋的一行import csv

s = """\

spu+--------------------------------------+--------+--------+------------+-------------+-----------------------------------+

| ID | Name | Status | Task State | Power State | Networks |

+--------------------------------------+--------+--------+------------+-------------+-----------------------------------+

| 6bca09f8-a320-44d4-a11f-647dcec0aaa1 | tester | ACTIVE | - | Running | OpenStack-net=10.0.0.1, 10.0.0.3 |

+--------------------------------------+--------+--------+------------+-------------+-----------------------------------+"""

result = [tuple(filter(None, map(str.strip, splitline))) for line in s.splitlines() for splitline in [line.split("|")] if len(splitline) > 1]

with open('output.csv', 'wb') as outcsv:

writer = csv.writer(outcsv)

writer.writerows(result)

我可以把它打开一点使它更漂亮：

^{pr2}$

或者可能更有用：result = []

for line in s.splitlines():

splitdata = line.split("|")

if len(splitdata) == 1:

continue # skip lines with no separators

linedata = []

for field in splitdata:

field = field.strip()

if field:

linedata.append(field)

result.append(linedata)