Python Sqlite

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Python Sqlite

georgebijum
Unladen Swallow

Posts: 4

Threads: 3

Joined: Apr 2022

Reputation: 0

May-04-2022, 10:12 AM

Hi ,

I am using the sqlite3 package in python. I push data to Sqlite table using to_sql function and is then querying data from multiple tables as per my reporting requirement . Need a help on string function used in my Python inline SQl .
Can you please advise how to filter out NonNumeric characters (A-Z) from CustomerID field in the selection statement. Tried using the general sql functions , regex, etc.
Thanks in Advance

Find

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	need help with data analysing with python and sqlite	Hardcool	2	388	Jan-30-2024, 06:49 AM Last Post: Athi
	python sqlite autoincrement in primary column	janeik	6	1,182	Aug-13-2023, 11:22 AM Last Post: janeik
	Help with subtracting values using SQLite & Python	Extra	10	3,452	May-10-2022, 08:36 AM Last Post: ibreeden
	[Solved]Help with search statement-SQLite & Python	Extra	1	1,069	May-06-2022, 07:38 PM Last Post: Extra
	Help With Python SQLite Error	Extra	10	15,182	May-04-2022, 11:42 PM Last Post: Extra
	Importing data from a text file into an SQLite database with Python	macieju1974	7	4,184	Jun-29-2020, 08:51 PM Last Post: buran
	how to use items combobox in table name sqlite in python	hampython	1	2,708	May-24-2020, 02:17 AM Last Post: Larz60+
	SQLite Query in Python	rowyourboat	2	2,824	Apr-26-2019, 02:24 PM Last Post: Larz60+
	how can a sqlite command like import be executed using sqlite3 (python)	Larz60+	1	2,643	Mar-08-2019, 01:17 AM Last Post: Larz60+
	finding problems connecting python to sqlite	Dennis	1	2,309	Dec-10-2018, 02:58 PM Last Post: Larz60+

Users browsing this thread: 1 Guest(s)

View a Printable Version

Python Sqlite

User Panel Messages

Announcements