UNIX for Dummies Questions & Answers

Hi All,

I am getting a input file which doesnt have a field seperator. The file is being sorted on certain positions say from 0.55 to 0.59. If there are any blanks from 0.55 to 0.59 they will be listed as first set of records. I am not sure abt the number of records which will have blanks at those positions (0.55 - 0.59), but have to exclude all those lines which have blanks from 0.55 to 0.59.

eg : sort -y -T /temp/usespace +0.55 -0.59 <input filename> >> <output filename>

Is there any one line command to this ??? If not then how to go abt this ???

Please let me know regarding the same.

Please post sample input and example of the desired output.

Code:

$ cat data
123456789012345678901234567890123456789012345678901234567890
123456789012345678901234567890123456789012345678901234     0

$ perl -ne 'print unless $_ =~ /^.{54} {5}/' data
123456789012345678901234567890123456789012345678901234567890

Pipe the output of this to your sort routine, or sort directly in perl.

you can use this simple awk command

Code:

awk '{if(substr($0,55,5)!="     "){print}}' filename

then you can pipe it to your sort command

Here goes the input file :
Name of the file is test
000000000XXXXXXX XXXXXXXX NOTIXABCDHH450
000000000XXXXXXX XXXXXXXX NOTIXABCDHH450
000000000YYYYYY YYYYY NOTIXPQRSPULSAR
000000000YYYYYY YYYYY NOTIXPQRSPULSAR
000000000ZZZZZ ZZZZZZZ NOTIXABCDHH450
000000000ZZZZZ ZZZZZZZ NOTIXABCDHH450
000000000PPPPPPP PPPPPPP PAGI5 0000
000000000PPPPPPP PPPPPPP PAGI5 0000
000000000ZALKIM FERER NOTIXABCDZM371
000000000ZALKIM FERER NOTIXABCDZM371


I run this command

cat test | sort -y -t /tmp/usespace +0.55 -0.59

Here is the output of it
000000000PPPPPPP PPPPPPP PAGI5 0000
000000000PPPPPPP PPPPPPP PAGI5 0000
000000000XXXXXXX XXXXXXXX NOTIXABCDHH450
000000000XXXXXXX XXXXXXXX NOTIXABCDHH450
000000000ZZZZZ ZZZZZZZ NOTIXABCDHH450
000000000ZZZZZ ZZZZZZZ NOTIXABCDHH450
000000000ZALKIM FERER NOTIXABCDZM371
000000000ZALKIM FERER NOTIXABCDZM371
000000000YYYYYY YYYYY NOTIXPQRSPULSAR
000000000YYYYYY YYYYY NOTIXPQRSPULSAR

Now the first 2 lines have 4 spaces between PAGI5 and 0000.
Similary there may be so many lines which have blanks from position 55 to 59. I want to exclude all those lines on a fly and write others to another file.

I want to exclude all lines that have spaces at those positions meaning starting at 55 and ending at 59

Let me know regarding the same.

Replace cat with the command either vidyadhar85 or I gave.

FYI: Place your code or output inside code blocks [ code ] ... [ / code ] (without any spaces inside the brackets).

Code:

egrep -v '^.{55}     '

(assuming your columns start at 1; use {54} for 0-based)