Number of lines in SQLite string

Question

I have an SQLite table where a column is of type 'text'. Each item in that column is program code. I want to find out how many lines each text item is. i.e. The following should be 3 lines:

program "help"
print "Help"
return.

Answer 1

You can count the \ns by doing

LENGTH(TheColumn) - LENGTH(REPLACE(TheColumn, X'0A', '')) + 1