Batch process CSV files delete entire row

Hello and thank you for your time.

I am trying manipulate some code that I found in another post "VBA to Delete Specific Columns 100s Files for .csv "

I started with the file that was linked to the above linked thread "EF975086 code.xlsm‎ " file and I'm trying to modify it. I'd like to delete the entire row if the text value matches what I have specified. I'm working with multiple csv files (batch) and all of the data is in column A. I've been able to get the macro to run but it does not delete the rows of data that I am trying to remove. Rather, there are no changes made.

I need to delete the row that contains the following strings.

Date/Time, Time stamp, Cycles of Channel 1, Channel 1-Displacement, Channel 1-Load, Channel 1-Dyn Load, Channel 1-Accel

s, s, cycles, mm, N, N, G

I very much appreciate your time on this matter.

Here is the edited code:

Please Login or Register  to view this content.

This line closes the workbook without saving -

Please Login or Register  to view this content.

I think if you change false to true it will work.

One more thing, you need to declare each variable individually in VBA. This line:

Please Login or Register  to view this content.

declares wb as a Workbook, and k2 as long, but the remaining variables will all default to variant. You should change the line to

Please Login or Register  to view this content.

See if this works.

Please Login or Register  to view this content.

Jindon,

Thank you for your reply. The code that you posted is what I'm looking for (batch processing). I'm just not sure how to make it look for the text that I'm trying to delete. I tried to replace the pattern ("([$()\|\\\[\]{}+*?.-])") with the text that I want to delete but it did not work. When I run the code you posted it deletes the blank rows in the worksheet.


I need to search the csv files for: "Date/Time, Time stamp, Cycles of Channel 1, Channel 1-Displacement, Channel 1-Load, Channel 1-Dyn Load, Channel 1-Accel" and "s, s, cycles, mm, N, N, G" and delete the rows that contain this text. Thank you very much for any advice you can offer!

No need to change the code.
All you need to do is place the criteria phrase from cell A2 down as the code you posted.

Jindon,

Thank you again for your help with this. I've never worked with Regex so I'm not able to do much troubleshooting. When I run this code it only deletes the empty rows but does not delete the strings that I am trying to remove. I've attached a small csv file that maybe will help. From this example.csv file I need to delete rows 13, 14, 19, 20. I could have the problem in that when the csv file is opened for editing, it opens it a comma delimited. I've replaced the long string with only "Date/Time" and "s" but that did not work for me either. Thank you for your time.

Ahh, OK.
I misread the question.

You should have
A2:
Date/Time, Time stamp, Cycles of Channel 1, Channel 1-Displacement, Channel 1-Load, Channel 1-Dyn Load, Channel 1-Accel
A3:
s, s, cycles, mm, N, N, G

Please Login or Register  to view this content.

Jindon,

This works!

Thank you very much for your help with this. I really appreciate it.