Utilizing Azure Data Factory for Parsing .dat Files with Custom Row Delimiters”

Question

I am employing Azure Data Factory to parse a DAT file where each row is delimited by the string ‘TASK.’ For instance, in the data preview, a new row is displayed each time the character ‘T’ appears. Is there a method to employ a row delimiter with a specific string value?

Example

TRY 123 ~ 946 TASK 3489YT56 TASK 368905T67 TASK 365890PT65678

Answer 1

Hi Glasier,

Thank you for posting query in Microsoft Q&A Platform. Try below steps.

Step1: Create a dataset with csv format and select your DAT file

Step2: Inside the dataset settings for row delimiter option.

Hope this will helps. Please let me know how it goes.

---

Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.

Answer 2

Hi, you can try editing the delimiter option in the data set where you are pointing to source dat file and mention the string delimiter there.

You can go through thisvideo for reference. Kindly check and revert in case you have questions.

Thanks.