CODEWITHSUNDEEP
python
giga
giga

Reputation: 327

Python - Split a string into list after a certain number of special characters

I have a python program which does a SOAP request to a server, and it works fine:
I get the answer from the server, parse it, clean it, and when I am done, I end up with a string like that:

name|value|value_name|default|seq|last_modify|record_type|1|Detail|0|0|20150807115904|zero_out|0|No|0|0|20150807115911|out_ind|1|Partially ZeroOut|0|0|20150807115911|...

Basically, it is a string with values delimited by "|". I also know the structure of the database I am requesting, so I know that it has 6 columns and various rows. I basically need to split the string after every 6th "|" character, to obtain something like:

name|value|value_name|default|seq|last_modify|

record_type|1|Detail|0|0|20150807115904|

zero_out|0|No|0|0|20150807115911|

out_ind|1|Partially ZeroOut|0|0|20150807115911|...

Can you tell me how to do that in Python? Thank you!

Upvotes: 1

Views: 240

Answers (5)

John Coleman
John Coleman

Reputation: 52008

Here is a flexible generator approach:

def splitOnNth(s,d,n, keep = False):
    i = s.find(d)
    j = 1
    while True:
        while i > 0 and j%n != 0:
            i = s.find(d,i+1)
            j += 1
        if i < 0:
            yield s
            return #end generator
        else:
            yield s[:i+1] if keep else s[:i]
            s = s[i+1:]
            i = s.find(d)
            j = 1

#test runs, showing `keep` in action:

test = 'name|value|value_name|default|seq|last_modify|record_type|1|Detail|0|0|20150807115904|zero_out|0|No|0|0|20150807115911|out_ind|1|Partially ZeroOut|0|0|20150807115911|'
for s in splitOnNth(test,'|',6,True): print(s)
print('')
for s in splitOnNth(test,'|',6): print(s)

Output:

name|value|value_name|default|seq|last_modify|
record_type|1|Detail|0|0|20150807115904|
zero_out|0|No|0|0|20150807115911|
out_ind|1|Partially ZeroOut|0|0|20150807115911|

name|value|value_name|default|seq|last_modify
record_type|1|Detail|0|0|20150807115904
zero_out|0|No|0|0|20150807115911
out_ind|1|Partially ZeroOut|0|0|20150807115911

Upvotes: 1

gms
gms

Reputation: 335

There are really many ways to do it. Even with a loop:

a = 'name|value|value_name|default|seq|last_modify|record_type|1|Detail|0|0|20150807115904' \
    '|zero_out|0|No|0|0|20150807115911|out_ind|1|Partially ZeroOut|0|0|20150807115911|'

new_a = []
ind_start, ind_end = 0, 0
for i in range(a.count('|')// 6):
    for i in range(6):
        ind_end = a.index('|', ind_end+1)
    print(a[ind_start:ind_end + 1])
    new_a.append(a[ind_start:ind_end+1])
    ind_start = ind_end+1

The print is just to saw the results, you remove it:

name|value|value_name|default|seq|last_modify|
record_type|1|Detail|0|0|20150807115904|
zero_out|0|No|0|0|20150807115911|
out_ind|1|Partially ZeroOut|0|0|20150807115911|

Upvotes: 0

PM 2Ring
PM 2Ring

Reputation: 55489

Here's a functional-style solution.

s = 'name|value|value_name|default|seq|last_modify|record_type|1|Detail|0|0|20150807115904|zero_out|0|No|0|0|20150807115911|out_ind|1|Partially ZeroOut|0|0|20150807115911|'

for row in map('|'.join, zip(*[iter(s.split('|'))] * 6)):
    print(row + '|')

output

name|value|value_name|default|seq|last_modify|
record_type|1|Detail|0|0|20150807115904|
zero_out|0|No|0|0|20150807115911|
out_ind|1|Partially ZeroOut|0|0|20150807115911|

For info on how zip(*[iter(seq)] * rowsize) works, please see the links at Splitting a list into even chunks.

Upvotes: 2

Ma0
Ma0

Reputation: 15204

How about this:

a = 'name|value|value_name|default|seq|last_modify|record_type|1|Detail|0|0|20150807115904|zero_out|0|No|0|0|20150807115911|out_ind|1|Partially ZeroOut|0|0|20150807115911|'
b = a.split('|')
c = [b[6*i:6*(i+1)] for i in range(len(b)//6)]  # this is a very workable form of data storage
print('\n'.join('|'.join(i) for i in c))  # produces your desired output

# prints:
#  name|value|value_name|default|seq|last_modify
#  record_type|1|Detail|0|0|20150807115904
#  zero_out|0|No|0|0|20150807115911
#  out_ind|1|Partially ZeroOut|0|0|20150807115911

Upvotes: 1

javidcf
javidcf

Reputation: 59731

data = "name|value|value_name|default|seq|last_modify|record_type|1|Detail|0|0|20150807115904|zero_out|0|No|0|0|20150807115911|out_ind|1|Partially ZeroOut|0|0|20150807115911|"
splits = data.split('|')
splits = list(filter(None, splits))  # Filter empty strings
row_len = 6
rows = ['|'.join(splits[i:i + row_len]) + '|' for i in range(0, len(splits), row_len)]
print(rows)
>>> ['name|value|value_name|default|seq|last_modify|', 'record_type|1|Detail|0|0|20150807115904|', 'zero_out|0|No|0|0|20150807115911|', 'out_ind|1|Partially ZeroOut|0|0|20150807115911|']

Upvotes: 1

Related Questions