Splitting strings in python in user defined manner

Question

I have data in the following format:

Input Data:

#@ <id_1d3s2ia_p3m_zkjp59>
<Eckhard_Christian>     <hasGender>     <ma<>le> .
#@ <id_1jmz109_1gi_t71dyx>
<Peter_Pinn<>e>   <created>       <In_Your_Arms_(Love_song_from_"Neighbours")> .
#@ <id_v9bcjt_ice_fraki6>
<Blanchester,_Ohio>     <hasWebsite>    <http://www.blanchester.com/> .
#@ <id_10tunwc_p3m_zkjp59>
<Hub_(bassi~st)> <hasGender>     <ma??le> .

Output Data:

<Eckhard_Christian>     <hasGender>     <male> <id_1d3s2ia_p3m_zkjp59>.
<Peter_Pinne>   <created>       <In_Your_Arms_(Love_song_from_"Neighbours")> <id_1jmz109_1gi_t71dyx>.
<Blanchester,_Ohio>     <hasWebsite>    <http://www.blanchester.com/> <id_v9bcjt_ice_fraki6>.
<Hub_(bassist)> <hasGender>     <male> <id_10tunwc_p3m_zkjp59>.

That is in the output data I want to delete all other characters except: alphanumeric and :,/,/,.,_,(,) between any two starting and ending < >. I know python allows me to split using string.split() but if I split using < > as demarkers then for <ma<>le> I get (<ma,<>,le>).

Is there some other way by which I may split in python so that I may get the data in the desired form. Also I want preceding lines < > (following # @) to appear as the last column.

tobias_k · Accepted Answer · 2015-04-06 12:04:08Z

1

Assuming that there is always a whitespace character before/after the "proper" < and >, you could try something like this, using regular expressions:

import re
with open('data') as data:
    for line in data:
        if line.startswith('#@'):
            id_ = re.search('\s(<.*>)', line).group(1)
            fields = re.findall('(<.*?>)\s', next(data))
            fields = ['<' + re.sub(r'[^\w:/._()"]', '', f) + '>' for f in fields]
            print fields + [id_]

Output:

['<Eckhard_Christian>', '<hasGender>', '<male>', '<id_1d3s2ia_p3m_zkjp59>']
['<Peter_Pinne>', '<created>', '<In_Your_Arms_(Love_song_from_"Neighbours")>', '<id_1jmz109_1gi_t71dyx>']
['<Blanchester_Ohio>', '<hasWebsite>', '<http://www.blanchester.com/>', '<id_v9bcjt_ice_fraki6>']
['<Hub_(bassist)>', '<hasGender>', '<male>', '<id_10tunwc_p3m_zkjp59>']

edited Apr 6, 2015 at 12:04

answered Apr 6, 2015 at 9:21

tobias_k

83.1k12 gold badges130 silver badges186 bronze badges

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

Collectives™ on Stack Overflow

Splitting strings in python in user defined manner

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