question

john-6888 avatar image
0 Votes"
john-6888 asked PRADEEPCHEEKATLA-MSFT commented

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

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

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

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.

95176-image.png

95169-image.png

95245-adf-derivedcolumn.gif

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.


image.png (114.1 KiB)
image.png (1.5 KiB)
adf-derivedcolumn.gif (679.0 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

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!

0 Votes 0 ·