Separating a string into a 2d array using two different splits

Question

I'm trying to input values into a CSV using a 2d array. I have a string which is separated by ',' to separate the values and ';' to separate each row.

string below;

text = 536924636,www.microsoft.com,http://www.microsoft.com/pkiops/crl/MicW;536924733,www.microsoft.com,http://www.microsoft.com/pkiops/certs/Mi;536925898,crl.microsoft.com,http://crl.microsoft.com/pki/crl/product;

I want to be able to split the rows into a 2d array like so

arr = reg.split([','][';'])

So that that it ends up like this;

arr =[ 
['536924636','www.microsoft.com','http://www.microsoft.com/pkiops/crl/MicW'],
['536924733','www.microsoft.com','http://www.microsoft.com/pkiops/certs/Mi'],
['536924636','www.microsoft.com','http://www.microsoft.com/pkiops/crl/MicW']]

but when I attempt this, I get the following error;

  arr = reg.split([','][';'])
TypeError: list indices must be integers or slices, not str

BoarGules · Accepted Answer · 2019-04-14 14:04:57Z

1

The function split() will split one string into one list. You can't make it produce two dimensions by passing it two parameters instead of one.

But you can call it twice, once for each delimiter:

>>> text = "536924636,www.microsoft.com,http://www.microsoft.com/pkiops/crl/MicW;536924733,www.microsoft.com,http://www.microsoft.com/pkiops/certs/Mi;536925898,crl.microsoft.com,http://crl.microsoft.com/pki/crl/product;"
>>> [r.split(",") for r in [r for r in text.split(";")]]
[
['536924636', 'www.microsoft.com', 'http://www.microsoft.com/pkiops/crl/MicW'], 
['536924733', 'www.microsoft.com', 'http://www.microsoft.com/pkiops/certs/Mi'], 
['536925898', 'crl.microsoft.com', 'http://crl.microsoft.com/pki/crl/product'], 
['']
]

answered Apr 14, 2019 at 14:04

BoarGules

17.1k3 gold badges29 silver badges46 bronze badges

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

1 Comment

tfw Over a year ago

Alternatively, [r.split(',') for r in text.split(';')].

Swastik Udupa · Accepted Answer · 2019-04-14 14:07:48Z

0

x = str(input())
arr  = x.split(";")
finalArr = []
for items in arr:
    arr2 = []
    arr2.append(items)
    finalArr.append(arr2)
print(finalArr)

Try this out. I am hoping this is what you are looking for.

answered Apr 14, 2019 at 14:07

Swastik Udupa

3163 silver badges19 bronze badges

Comments

Raf · Accepted Answer · 2019-04-14 18:37:02Z

0

A simple approach can be

arr = [i.split(',') for i in text.split(';')]

edited Apr 14, 2019 at 18:37

answered Apr 14, 2019 at 14:01

Raf

2161 silver badge5 bronze badges

3 Comments

Ac3 Over a year ago

I get the following error ; ``` arr = [[i] for i in arr.split(';')] AttributeError: 'list' object has no attribute 'split' ```

tfw Over a year ago

Your solution causes each entry to be double-nested lists, as your image also shows. It should not have [] around the i.split(',') part.

Raf Over a year ago

That's true! Thank you!

Collectives™ on Stack Overflow

Separating a string into a 2d array using two different splits

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related