SQLite has no looping. How can I accomplish looping?

I understand QLite has no looping. Here is what I want to accomplish. I have a row that has values: '1:2:3:4:5:6:7:8:9:10'

I want to display it as: 1 2 3 4 5 6 7 8 9 10

In Oracle I can accomplish this using a loop and function REGEXP_SUBSTR. How can I accomplis this with SQLite?