![]() ![]() ![]() Regex details: (?m) Match the remainder of the regex with the options: ^ and $ match at line breaks (m) If not, please provide a better example of the input file showing exactly what it looks like. You should now have a csv file that will open in Excel if you double-click it. If that is really what the file looks like, you can convert it to a CSV format that Excel will understand like this: (Get-Content -Path 'D:\Test\WeirdFormat.csv' -Raw) -replace '(?m)^(Header|rows):\s ' |Įxport-Csv -Path 'D:\Test\ExcelCanOpenThis.csv' -UseCulture -NoTypeInformation
0 Comments
Leave a Reply. |