Powershell: CSVs And NoTypeInformation

Dan Blank lays down some information about saving headerless CSV files in Powershell:

Anyway, a question was posted recently using the #pshelp hashtag on Twitter.  How do you replace the header line of multiple csv files at once?

I’m new at PS, so any help appreciated. I have a CSV file I want to remove the first/header line and replace with 2 different lines. I can store these in another CSV, just need help with how/where to remove and merge/insert #pshelp

— Matt Collins (@Zyber) March 29, 2018

If i use get-content and get 2 csv files into powershell, how do i output, what is now being shown in PS, to a csv? I’ve tried export-csv and add-content, but it’s not the data being shown in PS, think i need to call the PS output something to set it. #pshelp pic.twitter.com/VIcl4zCIih

— Matt Collins (@Zyber) April 3, 2018

I saw this and maybe cockily thought to myself, “that’s got to be an easy 2 liner, bet I can boost my ego and quickly write out a solution”.

Spoilers:  it turned out to be slightly more complex.