Text File - Moving Data into a new format

Nick Collins
Nick Collins used Ask the Experts™
on
Good Afternoon,

PPE_Data.txt

I am looking for a straight forward script that can re-sort the attached text file.

Source File

"Date:","PPE No."
"07 February 2019 07:06 AM","PPE_000018_1067414"

I would like to move PPE No to the 1st the column and it looks like the below

"PPE No.","Date:"
"PPE_000018_1067414","07 February 2019 07:06 AM"

Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
System Engineer | .NET Developer | Microsoft MVP | Technical Speaker
Commented:
This can be useful for you?

Import-Csv -Path .\PPE_Data.txt | Select "PPE No.", "Date:" | Export-Csv .\Data_PPE.txt -NoTypeInformation

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial