Delete the first 2 rows of a .csv file

Like (0) Share

Report

Posted on 8 May 2024 08:37:53 by ThomasH

170

Hello, i have in sharepoint a .csv file which have two empty Rows in first, i want to delete this Rows with Power Automate, how can i do that?

Thank you

All responses (13)

Answers (0)

ThomasH 170 on 29 May 2024 at 12:55:01

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

@AlexEncodian Ok, thank you, i think this is what i search for

ThomasH

170 on 29 May 2024 at 11:59:08

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

@AlexEncodian The .csv that I now get is comma (,) separated and the question is whether tab separator also works.

It look like this

Kalender-·Tag ID,Text HAHGI_O_MA_NR,(VA)·Text HGBF_MA_NR,(VA)·Text KURZDESC,Metriken,Anz. Text,Anz. Text VJ,Anz. Daten,Anz. Daten VJ

20240527,44 44 4545,44 44 4545,Text Text Text Text,,"2,656 ",0 ,"2,702 ",

ThomasH 170 on 29 May 2024 at 11:15:29

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

Hallo @AlexEncodian Thanks for your help, this works almost perfectly for me, but can I specifically specify that the .xlsx to .csv conversion is tabstop separate?
Thank you
AlexEncodian 4,409 Super User 2025 Season 1 on 24 May 2024 at 09:45:47

Like (1)

Report

Re: Delete the first 2 rows of a .csv file

@ThomasH

In the Convert excel action, looks like you are using a file path. You need to use the filename with the extension only.
ThomasH 170 on 24 May 2024 at 05:54:23

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

@AlexEncodian Hi, you mean this so?
DryMouse555 31 on 23 May 2024 at 23:15:38

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

Hi, that solution worked for me. But, in my case, I am getting one empty row at the end of csv file. The row count can be increased in the future and everytime, when I export the csv from the sources, I get this empty line. So, I can't mention the row numbers as they may change in the future.
Is there a way to remove empty row at the bottom by default?
ThomasH 170 on 23 May 2024 at 15:23:09

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

@AlexEncodian
Hello, sorry for the confusion. I tried a lot to solve the problem, including using the source file as .txt or .xlsx. If I have an .xlsx as the source file where I want to delete the first two lines, it now works if I solve it like in the screenshot.

However, it is then an .xlsx file and I need it as a .csv, which I then tried to achieve with the Encodian Excel Converter by attaching it to the flow as shown in the picture, but it works Flow then runs infinitely and doesn't stop with an error.

The current request is the .xlsx which I am now attaching here to clean up the top two lines and convert them to .csv, but somehow I can't get it solved. Thanks for the help

The Excel in the appendix is shortened; the original has around 160,000 lines

Test1.xlsx
ThomasH 170 on 21 May 2024 at 05:57:20

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

@AlexEncodian Hi, my Problem is, i wan't to have the Data in Columns, when i use a .txt as export and convert this with encodian to a .csv in the last Columns i put me la lot of commas.

Whe i import a .csv an delete the first t rows and save it as. csv, then i have no Columns, the content is only in the firts column.
AlexEncodian 4,409 Super User 2025 Season 1 on 14 May 2024 at 12:59:06

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

@ThomasH

Which action is failing and what is the error message
ThomasH 170 on 13 May 2024 at 07:47:56

Like (0)

Report

Re: Delete the first 2 rows of a .csv file

Hi @AlexEncodian , how i have to "create File" after "Delete Rows"?

I tried this way

So it dosn't work.

Thank you