Vertica - Split a column based on length
We are trying to split a column based on size. For example:
We need it be split at text size: 3 along with a seq_no
Is there anyway this can be achieved this. I have seen posts that do based on a delimiter but not size. Please assist if anyone is aware of a neat trick.