Revisions to How to sort by odd lines then remove repeated values?

improved formatting

Source Link

edited Jan 18, 2019 at 13:03

17.5k
4
41
46

for element in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}') do echo $element; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\-- done

for element in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}')
do
    echo $element; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\\\--
done

Where a.txt is your input. Tested:

[root@megatron ~]# cat a.txt transcr_25793 + YAL039C - transcr_25793 + YAL037C-B - transcr_20649 + YBL100C - transcr_7135 + YBL029C-A - transcr_11317 + YBL067C - transcr_25793 + YAL038W + transcr_7135 + YBL029W + [root@megatron ~]# for i in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}') do echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\-- done transcr_7135 YBL029C-A - YBL029W + transcr_11317 YBL067C - transcr_20649 YBL100C - transcr_25793 YAL039C - YAL037C-B - YAL038W + [root@megatron ~]#

[root@megatron ~]# cat a.txt
transcr_25793 +
YAL039C -
transcr_25793 +
YAL037C-B -
transcr_20649 +
YBL100C -
transcr_7135 +
YBL029C-A -
transcr_11317 +
YBL067C -
transcr_25793 +
YAL038W +
transcr_7135 +
YBL029W +
[root@megatron ~]# for i in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}')
do
echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\\\--
done
transcr_7135
YBL029C-A -
YBL029W +
transcr_11317
YBL067C -
transcr_20649
YBL100C -
transcr_25793
YAL039C -
YAL037C-B -
YAL038W +
[root@megatron ~]#

for element in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}') do echo $element; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\-- done

Where a.txt is your input. Tested:

[root@megatron ~]# cat a.txt transcr_25793 + YAL039C - transcr_25793 + YAL037C-B - transcr_20649 + YBL100C - transcr_7135 + YBL029C-A - transcr_11317 + YBL067C - transcr_25793 + YAL038W + transcr_7135 + YBL029W + [root@megatron ~]# for i in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}') do echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\-- done transcr_7135 YBL029C-A - YBL029W + transcr_11317 YBL067C - transcr_20649 YBL100C - transcr_25793 YAL039C - YAL037C-B - YAL038W + [root@megatron ~]#

for element in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}')
do
    echo $element; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\\\--
done

Where a.txt is your input. Tested:

[root@megatron ~]# cat a.txt
transcr_25793 +
YAL039C -
transcr_25793 +
YAL037C-B -
transcr_20649 +
YBL100C -
transcr_7135 +
YBL029C-A -
transcr_11317 +
YBL067C -
transcr_25793 +
YAL038W +
transcr_7135 +
YBL029W +
[root@megatron ~]# for i in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}')
do
echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\\\--
done
transcr_7135
YBL029C-A -
YBL029W +
transcr_11317
YBL067C -
transcr_20649
YBL100C -
transcr_25793
YAL039C -
YAL037C-B -
YAL038W +
[root@megatron ~]#

deleted 6 characters in body

Source Link

edited Jan 18, 2019 at 12:05

Zatarra

201
1
3

for element in sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}'$(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}') do echo $element; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\\-- done

Where a.txt is your input. Tested:


[root@megatron ~]# cat a.txt
transcr_25793 +
YAL039C -
transcr_25793 +
YAL037C-B -
transcr_20649 +
YBL100C -
transcr_7135 +
YBL029C-A -
transcr_11317 +
YBL067C -
transcr_25793 +
YAL038W +
transcr_7135 +
YBL029W +
[root@megatron ~]# for i in `sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}'`
> do
> echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\--
> done
transcr_7135
YBL029C-A -
YBL029W +
transcr_11317
YBL067C -
transcr_20649
YBL100C -
transcr_25793
YAL039C -
YAL037C-B -
YAL038W +
[root@megatron ~]#

[root@megatron ~]# cat a.txt transcr_25793 + YAL039C - transcr_25793 + YAL037C-B - transcr_20649 + YBL100C - transcr_7135 + YBL029C-A - transcr_11317 + YBL067C - transcr_25793 + YAL038W + transcr_7135 + YBL029W + [root@megatron ~]# for i in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}') do echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\-- done transcr_7135 YBL029C-A - YBL029W + transcr_11317 YBL067C - transcr_20649 YBL100C - transcr_25793 YAL039C - YAL037C-B - YAL038W + [root@megatron ~]#

for element in sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}' do echo $element; cat a.txt |grep -A1 $i |grep -v trans |grep -v \-- done

Where a.txt is your input. Tested:


[root@megatron ~]# cat a.txt
transcr_25793 +
YAL039C -
transcr_25793 +
YAL037C-B -
transcr_20649 +
YBL100C -
transcr_7135 +
YBL029C-A -
transcr_11317 +
YBL067C -
transcr_25793 +
YAL038W +
transcr_7135 +
YBL029W +
[root@megatron ~]# for i in `sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}'`
> do
> echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\--
> done
transcr_7135
YBL029C-A -
YBL029W +
transcr_11317
YBL067C -
transcr_20649
YBL100C -
transcr_25793
YAL039C -
YAL037C-B -
YAL038W +
[root@megatron ~]#

for element in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}') do echo $element; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\-- done

Where a.txt is your input. Tested:

[root@megatron ~]# cat a.txt transcr_25793 + YAL039C - transcr_25793 + YAL037C-B - transcr_20649 + YBL100C - transcr_7135 + YBL029C-A - transcr_11317 + YBL067C - transcr_25793 + YAL038W + transcr_7135 + YBL029W + [root@megatron ~]# for i in $(sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}') do echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\-- done transcr_7135 YBL029C-A - YBL029W + transcr_11317 YBL067C - transcr_20649 YBL100C - transcr_25793 YAL039C - YAL037C-B - YAL038W + [root@megatron ~]#

Source Link

answered Jan 18, 2019 at 12:00

Zatarra

201
1
3

for element in sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}' do echo $element; cat a.txt |grep -A1 $i |grep -v trans |grep -v \-- done

Where a.txt is your input. Tested:


[root@megatron ~]# cat a.txt
transcr_25793 +
YAL039C -
transcr_25793 +
YAL037C-B -
transcr_20649 +
YBL100C -
transcr_7135 +
YBL029C-A -
transcr_11317 +
YBL067C -
transcr_25793 +
YAL038W +
transcr_7135 +
YBL029W +
[root@megatron ~]# for i in `sed -n 'p;n' a.txt |sort -nk 1.9 |uniq |awk '{print $1}'`
> do
> echo $i; cat a.txt |grep -A1 $i |grep -v trans |grep -v \\--
> done
transcr_7135
YBL029C-A -
YBL029W +
transcr_11317
YBL067C -
transcr_20649
YBL100C -
transcr_25793
YAL039C -
YAL037C-B -
YAL038W +
[root@megatron ~]#

Stack Exchange Network

Return to Answer