Python - Concat variable output to string

Question

I am trying to concat output of a sql output to a string as below:

dwh_cur.execute("""select name from sales where id = 123""")
name = dwh_cur.fetchone()[0]
a = print(name)
b = str(a) + " is the name of the agent"
print(b)

The above returns

None is the name of the agent

Expected output:

Steve is the name of the agent

Remove a = , i.e.: print(name); b = f"{name} is the name of the agent" — Pedro Lobito
– Pedro Lobito, Commented Dec 13, 2018 at 12:29

Florian H · Accepted Answer · 2018-12-13 13:48:33Z

1

a = print(name)

returns None

Try:

b = "{} is the name of the agent".format(name)

edited Dec 13, 2018 at 13:48

answered Dec 13, 2018 at 12:22

Florian H

3,0722 gold badges16 silver badges27 bronze badges

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

4 Comments

bruno desthuilliers Over a year ago

The str(name) part is useless - name is already a string. And this would better be done using string formatting, ie b = "{} is the name of the agent".format(name)

Florian H Over a year ago

yes you're right. i just copied the line from him and changed 'a' to 'name' to make it work for him :)

bruno desthuilliers Over a year ago

But it's not too late to edit your post ;) (SO is not only about "making it work", it's also about "making it right").

Florian H Over a year ago

true, i edieted my post !

Collectives™ on Stack Overflow

Python - Concat variable output to string

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related