How to remove backslash ( \ ) in Azure Data Factory?

Question

I am trying to remove back slash in ADF.

Basically, I am copying data from Azure SQL table to a newly created csv file.

During the process, there is an instance where some data has backlash ( \ ) where it causes columns to be pushed to next and doing something weird to rows.

I am trying to find either an expression or way to do it.

I am not sure what to do here (Escape character) or Encoding.

I am thinking I need to come up with some type of expression..

Answer 1

@Anonymous

Data flow would be the sure bet, as Data Flow is intended for data transformation.

You would want to use a "Derived Column" transformation. For the relevant columns you would use expression

replace(myColumn, '\', '')  

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi there,

Please use this expression to overcome the error message.

replace($AlterDescription, '\\', '')

Hope this helps.

Answer 3

Hi there, we encountered the same issue and fixed it by using double quote both as the quote character and the escape character in the ADF dataset configuration. Please try and see if that solves the problem you're facing