#81. Azure Data Factory - Parse input files with custom delimeters

Normally, input files are either comma separated or pipe delimited or semi colon delimited. In real time scenarios, we can come across a situation where in we can get different kind of delimiters which might be hard to parse. This video explains the settings in Copy activity that we can make use of while we deal with files using a not so popular delimiters.

[saniasulthana]

Urgent help is needed.

How can I remove FYNPDnwmD\\ (need to remove one back slash)
2. “”LvfNrH6Qkf” (need to remove all the double quotes)

[Dineshkumar-yljk]

Hi, why we are using 3/4, what if it
is semicolon, what should we do..?

[ambujineebisoi]

Urgent help is needed!
I am getting two types of delimited files in my ADLS, regular is comma separated and sometimes semicolon separated. I want to read both files automatically in my copy activity and load them to the database. The default delimiter for a csv file is comma and whenever I am getting semicolon delimited then my pipeline is falling. Is there any option to read either comma or semicolon-separated files in a single copy activity?

[vasus_humour_club]

Thanks mam. This has Saved lot of my time.

[sunandhinim]

Wow. Such an easy thing.. without having to write any special script and all.

[rujutabele]

What if input file contains spaces as delimeter ?

[shaikanas]

Hi mdm,
If We use Edit option and give '/' delimiter straight away... will it work?