I wanted to remove certain pattern of contents based on a regex from csv file which is very large in size containing 100,000+ records, how is it possible via windows commandline? I also have sed and awk installed in my windows commandline

It hangs on opening in any spreadsheet processor or text editor(Including Notepad++).


You might want to try out Google Refine.

It can do complex refactoring of CSV's using several methods including REGEX.

I've used it to cleanse and manipulate very large user databases in CSV form.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.