Split a string on sqlite

Solar2D Lua Language
#1

Hi, I don’t know sqlite but I have to implement a database already done. The problem: i have a column called “answers” in this format: 

House,40|Bed,20|Mirror,10  

ecc.

I want to split the string and remove “,” “|” like this:

VARIABLE A=House VARIABLE A1=40 VARIABLE B=Bed VARIABLE B1=20 VARIABLE C=Mirror VARIABLE C1=10  

 

How can i do it with Lua?

I’m sorry for my english. Thanks to everybody.

#2

Search net for string split implementation in Lua - there’s plenty of it

#3

If you don’t need to search those values via SQL (ie, you’re just using it as a key->value store, there’s no reason you can’t just store json in a txt field. That might make your life easier going forward.

#4

Search net for string split implementation in Lua - there’s plenty of it

#5

If you don’t need to search those values via SQL (ie, you’re just using it as a key->value store, there’s no reason you can’t just store json in a txt field. That might make your life easier going forward.