how to remove & symbole in excel file using dataflow activity in azure

Question

i have a excel file in my source that file contains & and $ symboles i want to use dataflow to remove it.

Answer 1

Hello @john ,

Welcome to the Microsoft Q&A platform.

Use the derived column transformation to generate new columns in your data flow or to modify existing fields.

In ADF, you can use the replace expression language to replace a substring with the specified string and return the result string.

For more details, refer Derived column transformation in mapping data flow.

Hope this helps. Do let us know if you any further queries.

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

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.