Hello,
I came across a column split that I cannot easily solve:
I have a column that contains a text and date YYYY-MM-DD at the end. I would like to split the column in two: C1 (text), C2 (date). I tried splitting identifying the date with regex
Date length is always 10, and thinking of it, it may be useful to be able to split columns based on number of character from start or end.
Below data in which the first column has a size 10, second size 5, third 8
TEXT 1 123 34567
EXAMPLE 1 3 9875
T1 890 456678
In this case to get 3 columns one should to be able to split from start at position 11 and at 16 to get three columns. (#feature-request)