A friend of mine in finance posed an interesting question to me that I had never attempted before the other day. It quickly became evident that it would be alot of work so PowerShell came to mind. Here’s the short of it.
He has some finance application that he exports some sort of report from on a regular basis. He needs to combine/merge portions of the CSV files and analyze the data. The report comes in the form of a CSV (yippee!!). The problem is the format of the CSV (booo!!). The first column and the first 12 rows is all garbage. Essentially, I have many CSV files (100s) that I need to delete the first column and the first 12 rows then I can work with the good data.
I can delete the 12 rows like this.
Get-content -path c:\my.csv | Select-object -skip 12I haven't found a method to remove the first column, any ideas on that piece?