i want to remove special character @ symbol present in csv file im trying with escape charater but it is not working
i want to remove special character @ symbol present in csv file im trying with escape charater but it is not working
Hey,
Can you please mention the steps which you have tried with your source and sink details and what error you are getting ( if any?)
Hello @john-6888,
Thanks for the question and using 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 below suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.
Is this only work to remove the character @ ? what if there is other characters I don't know about?
In another way, Im looking to clean phone numbers (3 columns) - there might be special characters, letters and whitespaces, how can i remove all that? Thanks
You can try regexReplace() e.g.,
regexReplace('1234akdjhf567@dkjgkgj!SDFRC890', '[@!\\sa-zA-Z]', '')
Thanks!
Thanks for the above @nasreen-akter
I think regexReplace('1234akdjhf567@dkjgkgj!SDFRC890', '[@!\\sa-zA-Z]', '') created a new column, the out but is '1234567890' for all the rows.
My case, I do have a MobilePhone column, and i want to make sure that there's no whitespaces, letters or special characters in it. Thanks

7 people are following this question.