Sorry I know the post was a mess and not very clear. I'm trying to sort
non-sequential
It worked great! Thank you.
Powershell is so much fun when you know what you are doing. It looks like i
need more practice...
"Jacques Barathon [MS]" wrote:
> "Cornelius" <Cornelius@discussions.microsoft.com> wrote in message
> news:1544EB07-3A08-47EE-BB53-0DF3E2C12074@microsoft.com...
> >I need to read the content of a file and sort the content by fixed width.
> > Example file: sample_data.txt
> > 23abdc1133cdde
> > 14zzwd0034kkhe
> > 65ppok7780hyyh
> >
> > Read in the content and sort text by fixed position
> > (startpos:1,len:2)(startpos:3,len:4)(startpos:6,len:4)
>
> I am lost with your question: if you want to sort the file by the first two
> characters then the next four characters and finally the last four
> characters, won't sorting the whole line by default produce the expected
> result?
>
> PS> get-content sample_data.txt | sort
>
> However, if you want to sort on non-sequential patterns of your text the
> following should work:-
>
> --- sample_data.txt ---
> 23abdc1133cdde
> 14zzwd0034kkhe
> 65ppok7780hyyh
> 12abdc1133cdde
> --- sample_data.txt ---
>
> PS> # sort on 3rd to 6th chars, then on 1st to 2nd chars:
> PS> get-content sample_data.txt | sort {$_[2..5]},{$_[0..1]}
> 12abdc1133cdde
> 23abdc1133cdde
> 65ppok7780hyyh
> 14zzwd0034kkhe
>
> Hope that helps,
> Jacques
>
>