+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Python Sqlite (/thread-37131.html)
Python Sqlite - georgebijum - May-04-2022
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