'Azure data factory File Content Replace in the Azure blob

Good morning, We have Azure Data Factory (ADF). We have 2 files that we want to merge into one another. The files are currently in the Azure Blob storage. Below are the contents of the files. We are trying to take the contents of File2.txt and replace the '***' in File1.txt. When finished, it should look like File3.txt.

File1.txt
OP01PAMTXXXX01997
***
CL9900161313

File2.txt
ZCBP04178      2017052520220525         
NENTA2340      2015033020220330         
NFF232174      2015052720220527

File3.txt
OP01PAMTXXXX01997
ZCBP04178      2017052520220525         
NENTA2340      2015033020220330         
NFF232174      2015052720220527
CL9900161313

Does anyone know how we can do this? I have been working with this for 2 days and it would seem that this should not be a difficult thing to do.

All the best, George

azure-data-factory azure-data-factory-2 azure-data-factory-pipeline

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Azure data factory File Content Replace in the Azure blob

Sources

Related Questions