I have some log files in txt format that contain double tabbed columns. I'm using the following PowerShell:
Import-Csv C:\path\to\file\PageLog.txt -Delimiter "`t" | Export-Csv C:\path\to\file\PageLog.csv -NoTypeInformation
So nothing crazy there, and it is working, but I end up with an empty column with an automatically generated H1 header. So is it possible for me to treat these two tabs as one like when importing through the "Data" tab in Excel? Or somehow omit the empty H1 column during Export-Csv?