Batch file to search for and delete lines containing specific text

batchcsv

I have a bat file that searches a directory for specific .csv files names, and copies and amends the lines into a new .csv file.

However, some of the lines of the original .csv files are not information needed, and begin with PO-. I'd like to add to my bat a way to search for cells containing "PO-" and delete the entire line, and then save the results in a new .csv file. Is it possible?.

What I have so far in my .bat file is:

REM

@ Echo off

Echo on

type NUL>fdx.csv

copy pds*.csv fdx.csv

Best Answer

Perhaps you could use FIND

find /V "PO-" fdx.csv > new.csv

but you will get a header on the csv file that you have to remove manually

Related Solutions

Windows – How to Delete Duplicate Files with a Batch File

If you want to delete all the files with a name that ends in - ?, then you were close.

Try this:

FOR %%f IN ("C:\files\* - ?.*") DO del "%%f"

You will need to double up the percent signs if you are running it from a batch file. And test with an echo instead of a del first.

Windows Batch to read TXT and parse lines to CSV

command-line:

powershell $h=25;$f=gc data.txt;$f[$h..($f.count-1)]^|%{$_.Trim()-replace'\s+',','>>data.csv }

or:

powershell $h=25;$f=gc data.txt;$f[$h..($f.count-1)]^|%{('\"'+$_.Trim()+'\"')-replace'\s+','""";"""'^|ac data.csv}

powershell script:

$h=25;$f=gc data.txt;$f[$h..($f.count-1)]|%{$_.Trim()-replace'\s+',','>>data.csv}

or:

$h=25;$f=gc data.txt;$f[$h..($f.count-1)]|%{('"'+$_.Trim()+'"')-replace'\s+','";"'>>data.csv }

Best Answer

Related Solutions

Windows – How to Delete Duplicate Files with a Batch File

Windows Batch to read TXT and parse lines to CSV

Related Question