Split string and replace dot char in Lua

Question

I have a string stored in sqlite database and I've assigned it to a var, e.g. string

string = "First line and string. This should be another string in a new line"

I want to split this string into two separated strings, the dot (.) must be replace with (\n) new line char

At the moment I'm stuck and any help would be great!!

for row in db:nrows("SELECT * FROM contents WHERE section='accounts'") do
    tabledata[int] = string.gsub(row.contentName, "%.", "\n")
    int = int+1
end

I tried the other questions posted here in stachoverflow but with zero luck

Answer 1

What about this solution:`

s = "First line and string. This should be another string in a new line"
a,b=s:match"([^.]*).(.*)"
print(a)
print(b)