Importing data from a text file into an SQLite database with Python

[buran]

what I show you - is better. Obviously separator is '##'.

spam ='2020-05-22##18:00:00###RANGE ###RANGE ###RANGE ##201828##190182##96136##2  ##0  ###RANGE ###RANGE ##532387##644##313415'
eggs = [ele.strip() for ele in spam.split('##') if not ele.startswith('#RANGE')]
print(eggs)

Output:
['2020-05-22', '18:00:00', '201828', '190182', '96136', '2', '0', '532387', '644', '313415']

It's not clear if there could be case where instead of '#RANGE' you have a valid value and you need to handle such case.

for sqlite look at sqlite3 module