Delete rows from csv file manually

Question

Can you suggest a method to remove records from csv file, manually. I have a csv file with many records, I need to delete unwanted records. Is there any simplest method to remove the unwanted records.

Community · Accepted Answer · 2017-05-23 12:22:14Z

3

manually:

open the file in your desired text editor, i.e. notepad
delete the unwanted records (lines)
save the file

semi automatically: get a good text editor, notepad++, pspad, ... use the built in search and replace function, if you can provide an example string, or regular expression that can identify the unwanted records..

automatically: describe how an unwanted record differs from a wanted record. either by string comparision, regex, count of coloumns in row, or... put that logic into a script, like python, and have that run through the file. SO question on how to do that

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Mar 9, 2015 at 10:28

Henrik

2,23917 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GPH · Accepted Answer · 2015-03-09 10:25:13Z

2

You can open the file in the notepad application and just delete the rows you don't want?

answered Mar 9, 2015 at 10:25

GPH

1,9073 gold badges29 silver badges50 bronze badges

Collectives™ on Stack Overflow

Delete rows from csv file manually

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related