web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Delete the last empty ...

Power Automate

Answered

Delete the last empty line of a CSV File in Power Automate

(0) Share

Report

Report

Posted on by DryMouse555

31

Hi,

I have taken a csv file as input and did the transformation like, changing the headers, switching the column contents, adding a new row at the bottom.

Finally, I have exported the file in text format to OneDrive. When I open the file in notepad, I observed that there a empty line added at the bottom. Instead of 53 lines, I see 54.

I want to delete the last comma and the last empty line in my file. Please help we understand how to do it.

I really appreciate your help.

Thanks,

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @DryMouse555 ,

My TXT file content:

Please check this test:

substring(outputs('Get_file_content')?['body'],0,lastIndexOf(outputs('Get_file_content')?['body'],','))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
DryMouse555 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks so much Sunshine, it is working like a magic. Good job.

Cheers,

Was this reply helpful? Yes No

Join the conversation