'How to ignore lines with NUL in azure data factory

I have a row data in csv as shown below. The highlighted in bold letter is data for a particular cell. When I load this data in ADF data flow , the data gets shifted to next column. Is there any way to ignore the NUL ASCII so that it considers data for a cell.

Example:- 345435ed333241,null,CT, NUL"15 CG street, NY, XXXXX"NUL

enter image description here

enter image description here

My requirement is to get "34 downing street, LN, UK" under one column value.

azureazure-data-factoryazure-data-factory-2


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions