Parsing desired fields from output using regex

Question

I need to parse this output :-

S1-link-id   eNB-IP-Address   MME-IP-Address    Facing  State
-------------------------------------------------------------------
303          141.1.1.2        191.1.1.2         eNodeB  Established
301          141.1.1.2        191.1.1.2         MME     Established
306          141.1.1.3        191.1.1.2         eNodeB  Established
304          141.1.1.3        191.1.1.2         MME     Established
309          141.1.1.4        191.1.1.2         eNodeB  Established
307          141.1.1.4        191.1.1.2         MME     Established

I want to get multiple values for a single id (first column). For "303" - I need enb,mme ip addresses, facing and state values, same way for other ids.

regex for one desired output :-

\s*(?P<id>\d+)\s+(?P<enb_adr>\d+\.\d+\.\d+\.\d+)\s+(?P<mme_adr>\d+\.\d+\.\d+\.\d+)\s+(?P<facing>\w+)\s+(?P<state>\w+)\s*

Got stuck on how to proceed after this to get desired values for whole output.

TerryA · Accepted Answer · 2013-10-08 11:42:15Z

5

Looks like your regular expression is alright, so all you need to do is use re.findall():

import re
print re.findall(r'\s*(?P<id>\d+)\s+(?P<enb_adr>\d+\.\d+\.\d+\.\d+)\s+(?P<mme_adr>\d+\.\d+\.\d+\.\d+)\s+(?P<facing>\w+)\s+(?P<state>\w+)\s*', the_text_above)

Returns:

[('303', '141.1.1.2', '191.1.1.2', 'eNodeB', 'Established'), ('301', '141.1.1.2', '191.1.1.2', 'MME', 'Established'), ('306', '141.1.1.3', '191.1.1.2', 'eNodeB', 'Established'), ('304', '141.1.1.3', '191.1.1.2', 'MME', 'Established'), ('309', '141.1.1.4', '191.1.1.2', 'eNodeB', 'Established'), ('307', '141.1.1.4', '191.1.1.2', 'MME', 'Established')]

answered Oct 8, 2013 at 11:42

TerryA

60.2k11 gold badges122 silver badges148 bronze badges

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

Comments

Marcel Wilson · Accepted Answer · 2013-10-08 12:51:03Z

Even though @Haidro already answered the question, I wanted to impart a helpful suggestion for really long regexes like you have there. Comment your regex breakdown!

I'll be the first to admit, I suck at regex. I always come back to examples like this and thank 'past me' for being diligent with documentation. The key is to use flags=re.VERBOSE.

_brokendown_for_joo = re.compile("""
        get
            (As                 #/1
                (Int            #/2
                |Float
                |Boolean
                |String
                |StringList
                |Char)
            |Required
            )?
        [(]                     #opening paren       
            ['\"]               #single or double quotes
                (\w+)           #Anyword   /3
            ['\"]               #single or double quotes
                ,\s*            #comma and optional spaces
            ['\"]               #single or double quotes
                (\w+)           #Anyword  /4
            ['\"]               #single or double quotes
                (,\s*           #comma and optional spaces  /5
                (\w+            #anyword  /6
                |['][^']+[']    #or any chars in single quotes
                |[\"][^\"]+[\"] #or any chars in double quotes
                ))?
            \s*                 #optional spaces
        [)]                     #closing paren
        """, flags=re.VERBOSE)

Much easier to read than this.

re.compile(r"(%s)[.]get(As(Int|Float|Boolean|String|StringList|Char)|Required)?[(]['\"](\w+)['\"],\s*['\"](\w+)['\"](,\s*(\w+|['][^']+[']|[\"][^\"]+[\"]))?\s*[)]")

Collectives™ on Stack Overflow

Parsing desired fields from output using regex

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related