i have a excel file in my source that file contains & and $ symboles i want to use dataflow to remove it.
i have a excel file in my source that file contains & and $ symboles i want to use dataflow to remove it.
Hello @john-6888,
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.
Hello @john-6888,
Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Hello @john-6888,
Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!
5 people are following this question.