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
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