html - Splitting digits only from list prints in python and save into CSV

Question

how to split the numbers in the output (the list) its large though and then export into CSV

print(list) output

['id=31535&requestId=16152331&ln=143833']
['id=31539&requestId=16152331&ln=143833']
['id=31540&requestId=16152331&ln=143832']
['id=31541&requestId=16152331&ln=143831']
['id=31542&requestId=16152331&ln=143845']

Answer 1

Using regex you could do this:

import re
import csv
fn = 'csvtest1.csv'
din = [['id=31535&requestId=16152331&ln=143833'],
['id=31539&requestId=16152331&ln=143833'],
['id=31540&requestId=16152331&ln=143832'],
['id=31541&requestId=16152331&ln=143831'],
['id=31542&requestId=16152331&ln=143845']]
with open(fn, 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['Col1', 'Col2', 'Col3'])
    for itm in din:
        writer.writerow(re.findall(r'd+', str(itm)))

This would yield csv formatted file named csvtest1.csv which contains the following:

'Col1',    'Col2',      'Col3'
 31535,    16152331,   143833
 31539,    16152331,   143833
 31540,    16152331,   143832
 31541,    16152331,   143831
 31542,    16152331,   143845
?