Friday, November 27, 2015

CSV File Cleanup

If you ever wanted to save a google search to a CSV file, you should check out SEOquake.

Recently I used SEOquake to generate 50 CSV files.  The end goal was to work with these CSV files in Powershell.  Unfortunately, each of the original files had a header that I wanted to remove.

I used the following powershell code to strip out the first 6 lines of each of these files:



After running that powershell code, I can now work with SEOquake output more easily inside of other powershell scripts.