Python Forum
iterate through query result
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
iterate through query result
#3
You cannot strip that stuff out because it isn't there. kpbs[14] returns a tuple, and this is how a tuple prints. If you want pretty formatting you should look at using "format". If you are fine with just 1918, you can get the string from the tuple and print that.

Do you think there's a chance your other problems are also caused by the fact that you are using a tuple instead of a string?
Reply


Messages In This Thread
iterate through query result - by bigt - Mar-25-2020, 06:16 PM
RE: iterate through query result - by bigt - Mar-25-2020, 07:55 PM
RE: iterate through query result - by deanhystad - Mar-25-2020, 08:03 PM
RE: iterate through query result - by bigt - Mar-25-2020, 08:14 PM
RE: iterate through query result - by deanhystad - Mar-25-2020, 09:28 PM
RE: iterate through query result - by bigt - Mar-25-2020, 11:12 PM
RE: iterate through query result - by bigt - Mar-26-2020, 02:27 PM
RE: iterate through query result - by deanhystad - Mar-26-2020, 03:53 PM
RE: iterate through query result - by buran - Mar-26-2020, 03:57 PM
RE: iterate through query result - by bigt - Mar-26-2020, 04:32 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Write SQLite query result to file hjk6734 1 2,711 May-27-2020, 12:17 PM
Last Post: menator01
  python code (embedded in Redshift) to return result of the query Mel 0 2,932 Aug-24-2018, 06:12 PM
Last Post: Mel

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020