question

anonymousmind-4997 avatar image
0 Votes"
anonymousmind-4997 asked RyanAbbey-0701 commented

Substring by specific length in ADF

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.

sample output

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

azure-data-factory
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

what's wrong with

substring("0126 PersonA0230 PersonB", 1, 2)

1 Vote 1 ·

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

0 Votes 0 ·

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

0 Votes 0 ·
Show more comments

0 Answers