I have to delete first 4 rows from CSV

Help Activities
, ,
1

Hi Team,

I have to delete first 4 rows from CSV file

Input:

This image shows a spreadsheet detailing a LTE Technology Report, with ZoneCos as the report subtype, starting on February 11, 2025, listing companies and network details across various countries. (Captioned by AI)
This image shows a spreadsheet detailing a LTE Technology Report, with ZoneCos as the report subtype, starting on February 11, 2025, listing companies and network details across various countries. (Captioned by AI)932×338 37.5 KB

Output:

The image shows a spreadsheet listing various telecommunications networks by country, associated with Etihad Etisalat Company, with specific networks in Afghanistan, Albania, Algeria, and Andorra. (Captioned by AI)
The image shows a spreadsheet listing various telecommunications networks by country, associated with Etihad Etisalat Company, with specific networks in Afghanistan, Albania, Algeria, and Andorra. (Captioned by AI)678×301 7.64 KB

Anyone please help

Thanks
Shaik

2

Hi @Mukthar_Valli

Check the below thread.

Your regex will be changed as below:

strCSV = System.Text.RegularExpressions.Regex.Replace(strCSV,"(?<=^)(.*\n){4}","")

Hope it helps!!

3

Hi @Mukthar_Valli

Try this,

dt = dt.AsEnumerable().Skip(4).CopyToDataTable()

4

When CSV File we recommend, not much to work/open/inspect this in Excel but within a mature Texteditor e.g. notepad++

When it is a CSV File, we can do cleansing on the Text File Base directly like:

grafik
grafik392×168 13.3 KB

Text: String.Join(Environment.NewLine, System.IO.File.ReadLines("YourFullPathToTheCSV").Skip(4))

1 Like
5

Hi @Parvathy

rows are deleted from 2 row not from 1 row, please check

I have to delete first 4 rows

Thanks
Shaik

6

How about the following expression?

System.Text.RegularExpressions.Regex.Replace(strCSV,"^(.*\n){4}","")

Regards,

7

Hi @Mukthar_Valli

Try this syntax:

strCSV = System.Text.RegularExpressions.Regex.Replace(strCSV,"(?<=^)(.*\n){4}","")

Hope it helps!!

8

@Yoichi Thank you it’s working fine

thanks
shaik

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.