Dividing STRING with delimiters

I have to divide a STRING value with the "." delimiter into two values. Like this:

Input:

Output:

You can use string-function split, which accepts a regex and returns an array:

select var0,
    split(var0, '[\.]')[0] as var1,
    split(var0, '[\.]')[1] as var2
from mytable