Re: which command I should use to output sequentially,
On Wed, Jul 27, 2011 at 1:36 PM, Ivan Shmakov <ivan@gray.siamics.net> wrote:
>>>>>> lina <lina.lastname@gmail.com> writes:
>
> First of all, a kindly reminder: there's a news:comp.unix.shell
> newsgroup (also available via Google Groups [1], though a proper
> newsreader software is recommended), with a few truly
> knowledgeable folks among the subscribers, which such questions
> should've been pointed to.
>
> [1] http://groups.google.com/group/comp.unix.shell/
>
> […]
>
> > I just remember the sort command, but I still don't know how to get
> > the ideal one,
>
> > after I tried the sort -n -k2 , something changed on field 2 but it's
> > still a bit away from the one I need.
>
> Unfortunately, the numeric (-n) sort cannot be performed over
> the field that contains numbers prefixed with arbitrary strings.
> Therefore, it's necessary to split such a field into the
> separate prefix and number parts, like (assuming GNU Sed):
>
> $ sed -e 's/^\(\s*\w\+\s\+[^0-9[:blank:]]\+\)\([[:digit:]]\+\)/\1 \2/'
> 238CHO C10 3617 1.697 5.334 9.317
> 238CHO C11 3624 1.665 5.468 9.092
> ^D
> 238CHO C 10 3617 1.697 5.334 9.317
> 238CHO C 11 3624 1.665 5.468 9.092
> $
>
> Then, the output may be sorted on the now-third column, and the
> extra space removed. Thus:
>
> $ sed -e 's/^\(\s*\w\+\s\+[^0-9[:blank:]]\+\)\([[:digit:]]\+\)/\1 \2/' \
> | sort -nk 3,3 -k1,1 \
> | sed -e 's/^\(\s*\w\+\s\+[^0-9[:blank:]]\+\)\s\([[:digit:]]\+\)/\1\2/'
>
> […]
Thanks, but there is another problem here, about the first field,
which I wish it can be consequentially (mainly keep it present sequential),
Here is the list, a bit longer,
237CHOL H29 3583 3.341 1.693 9.809
237CHOL O28 3584 3.416 1.677 9.744
237CHOL C3 3585 3.383 1.746 9.624
237CHOL C4 3586 3.266 1.686 9.544
237CHOL C5 3587 3.251 1.760 9.411
237CHOL C10 3588 3.373 1.749 9.320
237CHOL C1 3589 3.483 1.814 9.404
237CHOL C2 3590 3.511 1.748 9.540
237CHOL C6 3591 3.135 1.819 9.381
237CHOL C7 3592 3.112 1.886 9.245
237CHOL C8 3593 3.216 1.831 9.148
237CHOL C9 3594 3.364 1.825 9.187
237CHOL C11 3595 3.450 1.764 9.077
237CHOL C12 3596 3.432 1.853 8.954
237CHOL C13 3597 3.287 1.843 8.907
237CHOL C14 3598 3.201 1.907 9.017
237CHOL C15 3599 3.063 1.908 8.953
237CHOL C16 3600 3.085 1.906 8.803
237CHOL C17 3601 3.235 1.912 8.782
237CHOL C19 3602 3.380 1.597 9.303
237CHOL C18 3603 3.247 1.695 8.905
237CHOL C20 3604 3.293 1.855 8.652
237CHOL C21 3605 3.438 1.900 8.642
237CHOL C22 3606 3.216 1.907 8.530
237CHOL C23 3607 3.244 1.802 8.423
237CHOL C24 3608 3.141 1.831 8.313
237CHOL C25 3609 3.207 1.836 8.175
237CHOL C26 3610 3.107 1.805 8.064
237CHOL C27 3611 3.247 1.982 8.150
238CHOL H29 3612 1.573 5.345 9.781
238CHOL O28 3613 1.640 5.282 9.743
238CHOL C3 3614 1.609 5.284 9.603
238CHOL C4 3615 1.702 5.187 9.529
238CHOL C5 3616 1.689 5.193 9.376
238CHOL C10 3617 1.697 5.334 9.317
238CHOL C1 3618 1.598 5.425 9.390
238CHOL C2 3619 1.623 5.423 9.541
238CHOL C6 3620 1.693 5.077 9.310
238CHOL C7 3621 1.697 5.086 9.157
238CHOL C8 3622 1.741 5.222 9.102
238CHOL C9 3623 1.663 5.336 9.168
238CHOL C11 3624 1.665 5.468 9.092
238CHOL C12 3625 1.638 5.452 8.942
238CHOL C13 3626 1.734 5.354 8.874
238CHOL C14 3627 1.709 5.225 8.952
238CHOL C15 3628 1.784 5.122 8.869
238CHOL C16 3629 1.739 5.167 8.731
238CHOL C17 3630 1.696 5.313 8.733
238CHOL C19 3631 1.839 5.384 9.345
238CHOL C18 3632 1.878 5.403 8.892
238CHOL C20 3633 1.764 5.397 8.625
238CHOL C21 3634 1.739 5.546 8.648
238CHOL C22 3635 1.747 5.342 8.484
238CHOL C23 3636 1.855 5.386 8.384
238CHOL C24 3637 1.808 5.343 8.245
238CHOL C25 3638 1.906 5.379 8.134
238CHOL C26 3639 1.851 5.324 8.002
238CHOL C27 3640 1.940 5.528 8.123
>
> --
> FSF associate member #7257
>
>
> --
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
> Archive: [🔎] 86livkp9o3.fsf@gray.siamics.net">http://lists.debian.org/[🔎] 86livkp9o3.fsf@gray.siamics.net
>
>
--
Best Regards,
lina
Reply to: