Find/Delete In Files From An Array

[bp83]

Good morning. I have reviewed posts in regards to find/replace in files and am wondering if someone may have come across this and found a solution.

I have a master xlsx file that has an array of invalid account numbers and I have a directory containing several hundred csv and xlsx files that may or may not contain valid and invalid account numbers.

Is there anyway using UE 15.10 to write a find in files expression that compares the array of invalid accounts to all files within the directory and for each invalid account found, delete each row containing an invalid account number in each file where it is found? Is this possible? Thanks.

[Mofi]

For CSV files the answer on your question is YES, for XLSX files the answer is NO.

A script is necessary for that task, but similar scripts already exist in the forum. Which script code lines are really necessary depends on real data of the CSV files and the file containing the invalid account numbers.

[bp83]

Thank you. I should have checked the scripting page before posting.