Parsing show ap stats ethernet summary command about textfsm

[byadair]

import textfsm
import tempfile
a="""AP1 GigabitEthernet0 UP 1000
GigabitEthernet1 DOWN AUTO
AP2 GigabitEthernet0 UP 1000
AP3 GigabitEthernet0 UP 1000"""

t="""Value Filldown AP_NAME (\S+)
Value Filldown PORT (\S+)
Value Filldown STATUS (\S+)
Value Filldown SPEED (\S+)

Start
^${AP_NAME}?\s+${PORT}\s+${STATUS}\s+${SPEED}\s*$$ -> Record
"""

tf=tempfile.TemporaryFile("r+")
tf.write(t)
tf.seek(0)
tx=textfsm.TextFSM(tf)
result=tx.ParseText(a)
print(result)

[marceardz]

Thanks @byadair this was super helpful!!! Do you know if there is a way of filling the Name column for the ones that have multiline? As with the proposed solution the multilines are now being included, which is great!! But the Name attribute is not getting repeated and is showing up as blank. Like this:
AP1 GigabitEthernet0 UP 1000
GigabitEthernet1 DOWN AUTO
AP2 GigabitEthernet0 UP 1000
AP3 GigabitEthernet0 UP 1000

[byadair]

Sorry for wrong scripts.

import textfsm
import tempfile
a="""AP1 GigabitEthernet0 UP 1000
GigabitEthernet1 DOWN AUTO
AP2 GigabitEthernet0 UP 1000
AP3 GigabitEthernet0 UP 1000
"""

t="""Value Filldown AP_NAME (\S+)
Value PORT (\S+)
Value STATUS (\S+)
Value SPEED (\S+)

Start
^${AP_NAME}\s+${PORT}\s+${STATUS}\s+${SPEED}\s* -> Record
^${PORT}\s+${STATUS}\s+${SPEED}\s* -> Record

EOF"""

tf=tempfile.TemporaryFile("r+")
tf.write(t)
tf.seek(0)
tx=textfsm.TextFSM(tf)
result=tx.ParseText(a)
for line in result:
print(line)

#['AP1', 'GigabitEthernet0', 'UP', '1000']
#['AP1', 'GigabitEthernet1', 'DOWN', 'AUTO']
#['AP2', 'GigabitEthernet0', 'UP', '1000']
#['AP3', 'GigabitEthernet0', 'UP', '1000']

[marceardz]

Thanks @byadair, I was about to update the thread saying that adding an extra record will fix the issue!! Thanks for all the learnings!! I added a "Required" as well in one of the attributes to remove the extra filldown from the last row.