
Running into a weird problem I can't figure out. Each day I have a CSV Report that is emailed from Salesforce. I have a PowerAutomate flow that parses it, and imports it into a list. The 3rd column is a date, ie 01/12/2024.. When the flow runs, it is putting /r on the end of the date (it's the last column). I have this to remove it:
Have you checked the special characters at the end of the line in both cases. What do you use to split the lines. Maybe sometimes there is CR and LF at the end and sometimes not.