question

User2508 avatar image
0 Votes"
User2508 asked MartinJaffer-MSFT commented

Can we read specific area of a delimited files in Azure data factory?

Can we read specific area of a delimited files in Azure data factory?

ex :-
Header1

Name
Place

Footer1

I want to read data which is between header and footer only. is it possible?

azure-data-factory
· 2
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.

@User2508 did my response help you? If it answered your query, please mark as accepted answer. If not, please let me know how I may better assist.

0 Votes 0 ·

@User2508 if you found your own solution, please share here with the community.

0 Votes 0 ·

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered

Hello @User2508 and welcome to Microsoft Q&A.

Thank you for your question. This is partially possible, given current capabilities, please let me break this down.

It is possible to skip a header, using First row as header dataset option in the case of the first row just being column names, or the Skip line count copy activity option in the case of a multiline header.

However a footer is much more difficult, and I do not think there is currently a way to handle that.

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.