Can I split up the values from one text field into multiple text fields?
- by spencewah
I have a text field that stores a combination of three values, ':' delimited. (looks like A:B:C).
I'd like to split those values into three actual columns in the table, but I'm not sure of the best way to go about doing this. I'm using sqlite3, any help super appreciated!