Substring by specific length in ADF

anonymous_mind 6

Hi Im new to ADF expression. I would like to ask on how to write expressions properly.

I have a text file as delimited text for dataset with a value "0126 PersonA0230 PersonB".

this is the format I would like to accomplish as column in ADF.

No ->01 - 2 char
Age ->26 - 2 char
Name -><space>PersonA - 8 char including space.

So the output should be like this.

Is there a way on how to have an output like the image above?

Ryan Abbey 1,181 Reputation points

2021-07-27T03:57:00.637+00:00

what's wrong with

substring("0126 PersonA0230 PersonB", 1, 2)
Ryan Abbey 1,181 Reputation points

2021-07-27T03:57:41.693+00:00

copy paste error... for "No" should be substring("0126 PersonA0230 PersonB", 0, 2) as it's 0-indexed
anonymous_mind 6 Reputation points

2021-07-27T04:05:32.663+00:00

Yes I tried substring("0126 PersonA0230 PersonB", 1, 12) which output is "0126 PersonA". How can make this as record for my columns which is

No | Age | Name
01 | 26 | PersonA
Ryan Abbey 1,181 Reputation points

2021-07-27T05:39:25.513+00:00

You'll have to repeat the substring for each column

Your answer