storing values from table column to array in Python

Question

I'm connecting access db and fetching values. In one of the column values are stored like

abc|def|ghi|xyz.

Need to replace | with space and store in array.

I'm trying below code but each character is stored in array like "a b c ..."

for row in cursor.fetchall():
   names = row[1]
   names = names .replace("|", ",")

namesarray = []
namesarray = names

for fullname in (namesarray):
 --do something --

Maybe you want names=names.split("|") instead of replacing with comma? — pault
– pault, Commented Jul 21, 2018 at 17:04

Theo Vasileiadis · Accepted Answer · 2018-07-21 17:23:45Z

1

Try:

for row in cursor.fetchall(): names = row[1] names_arr = names.split('|') print (names_arr)

answered Jul 21, 2018 at 17:23

Theo Vasileiadis

2091 silver badge9 bronze badges

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

Collectives™ on Stack Overflow

storing values from table column to array in Python

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