Need help in this project

Help
, ,
1

I have an csv file and another csv file with some keywords.
I need a script that will open a.csv, check for the first keyword in b.txt which is nigeria.
It filters out every domain name(column B) that contains that word - nigeria, it will copy out column B, column K, column Q, column R, column S, column AB and column AL.
It will then rename it nigeria-12-02-2020.csv
It will then loop to the next keyword in b.txt which is ng
It filters out every domain name(column B) that contains that word - ng, it will copy out column B, column K, column Q, column R, column S, column AB and column AL.
It will then rename it ng-12-02-2020.csv
It will continue looping till it gets to the last keyword.
Find attached the files and also the output for your understanding.