How to Convert from String to Tuple in python?

Question

When I am retrieving a record from DB getting the record as below

('("2014-02-21 07:10:40",ManualNo,184,vsp,AP10123456,aaaaa,Coconut-Na,5,10)',)

and I need to get the data as tuple like:

("2014-02-21 07:10:40",ManualNo,184,vsp,AP10123456,aaaaa,Coconut-Na,5,10)

without using split function and then want to get the individual values from it.

like

record[0] = 2014-02-21 07:10:40
record[1] = ManualNo

and so on...

How are you getting that record from the DB - could you show the code for that? I get a feeling this might be a wild goose chase... — Jon Clements
– Jon Clements, Commented Mar 7, 2014 at 10:09

Balthazar Rouberol · Accepted Answer · 2014-03-07 10:08:47Z

1

You can simply split the string over the comma:

data = ('("2014-02-21 07:10:40",ManualNo,184,vsp,AP10123456,aaaaa,Coconut-Na,5,10)',)
record = data[0].lstrip('(').rstrip(')').split(',')

answered Mar 7, 2014 at 10:08

Balthazar Rouberol

7,2302 gold badges37 silver badges41 bronze badges

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

1 Comment

user3392001 Over a year ago

We know how the retrieve by splitting the string but what I need is to convert the String into tuple. If we have comma in between the value it will not work.

Collectives™ on Stack Overflow

How to Convert from String to Tuple in python?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related