how can I split the column by delimiter in direct query?

I have a data table that I reach by direct query mod in Oracle. I have a column with the following format 1111.2222.33333.44444444.5555.666.77777

I would like to split column to 7 seven different column by delimiter so first column has a value of 1111 second is 2222 third 33333 etc. I tried to use in the query editor the split column. However in direct query this feature is not supported.

Is there any way to split that column in the query? If not how can I create a measure that split by a delimiter? For the first I can use left, but after?

Thanks