ADF: Replacing carriage returns in Data Factory expression language

Replace expressions

This one had me stumped lately.

I had an variable in ADF where the value contained carriage returns. I needed to remove them.

I guessed that would be easy:

@replace(variables('fileContent'), '\r', ")

But no matter what variation of this I tried, it wouldn't remove them.

Thanks to the genius of fellow MVP Simon Sabin, the answer was:

@replace(variables('fileContent'),base64ToString('DQ=='),")

Note: if you need a line feed (LF) it's base64ToString('Cg==') and a carriage return / line feed pair (CRLF), is base64ToString('DQo=').

Thanks Simon, and I hope this helps someone else.

Note: if you need a linefeed it's base64ToString('Cg==') and a carriage return / line feed pair, is base64ToString('DQo=').

2 thoughts on “ADF: Replacing carriage returns in Data Factory expression language”

  1. Just another frustrated Microsoft BS consumer here, who wanted to say thank you.

Leave a Reply

Your email address will not be published. Required fields are marked *