Hello,
I am currently reading a .txt file into an Power Automate Cloud Flow. I break up each row within the file using an Apply to Each action. Next I grab specific values for each row, which I then used to build out a new String/line of text within the Cloud Flow.
Basically for each row the incoming/trigger file has, I build out a NEW line of text/row using values from the trigger file.
The issue is that the final value within a row from the trigger .txt file I am using as a data source contains a return character.
Function I use to grab the 12.942 value: replace(outputs('Parse_Current_EB_File_Row')?[8], '"', '')
Functions I've used to try and omit the \r:
1.) replace(replace(outputs('Parse_Current_EB_File_Row')?[8], '"', ''), decodeUriComponent('%0A%0D'),'')
2.) replace(replace(outputs('Parse_Current_EB_File_Row')?[8], '"', ''), ' ','')
I have also attempted using a replace() call with a variable containing a new line. None of any of these approaches work.
