Hi
I want to read a .txt file with below format:
XXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXX <<<< Header
XXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX <<<< Row 1
XXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX <<<< Row 2
XXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXX <<<< Row 3
XXXXXXXXXXXXXXXXXXXXXX <<<< Footer
-------------Column 1----------------- --------Column 2--------- -------------Column 3-----------
I want to read and replace Column 2 values based on a condition for row 1, row 2 and row 3.
Do not want to changes header and footer.
Can please advise how to do this in Power Automate Cloud flow?
Regards,
Abhishek Verma