Avatar of Nick Collins
Nick Collins
 asked on

Powershell Script - Sorting the output in a logical order

Good Afternoon,

I currently have a power shell script that extracts data from a CSV source file and writes a new output file.

Script -

CSV Source File:

Output File:

I want to able to the sort the output file into the following order based on the headings below

1. Order Number
2. Please enter either the Plot Number, Garage Number or an area where the work is being done?
3. the following scaffolding which is either

So the new output file will look this

"HV_000024_1150980","189 188 plot ","Handing-Over"
Powershell

Avatar of undefined
Last Comment
footech

8/22/2022 - Mon
EXPERT CERTIFIED SOLUTION
footech

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
footech

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck