Search Results

Variations of vgersh99's solution which don't rebuild $0 when $2 is non-negative:

awk '$2>=0 || ($2=1)' OFS='\t' myFile

or

awk '$2<0 {$2=1} 1' OFS='\t' myFile

Regards,
Alister

awk '{$2=($2<0)?1:$2}1' OFS=='\t' myFile

OFS variable you have to use like below
awk '{$2=($2<0)?1:$2}1' OFS='\t' myfile

awk '{$2=($2<0)?1:$2}1' myFile
OR
sed 's/-[0-9][0-9]*/1/' myFile

awk -v s=100 '{print $1-s, $2+s}' myFile

As long as all of your input lines are in the same format and have data in the 3rd field in the same order, the easy way to do this is just to use tab, equal sign, and semicolon as field separators...

See if this helps

awk ' {gsub("[^0-9]|Value4",",",$NF); split($NF,a,","); for (i in a) $NF=a[3]+a[4]+a[5]+a[6] }1 ' inputfile

Indeed there are GGG's, so the G's should shift per 1 therefore GG kan not be used a record separator. So then this should do, which should work with any awk:

awk 'p~/GG$/{print p} {$0=p $0;...

This has its flaws as you will see but it is a starter...

#!/bin/bash --posix
textfile=$(tr -d '\n' < ~/flatfile.dat)
echo ""
echo "$textfile"
echo ""
for n in $( seq 19 1 ${#textfile} )
do...

grep -B1 -f ...

Using grep command with -f and -v option:
echo -e "deleted\n$( grep -f A.txt -v B.txt )"
echo -e "added\n$( grep -f B.txt -v A.txt )"

The comm utility sounds like what you want, then. It outputs three columns -- lines only found in file 1, lines only found in file 2, and lines found in both. It needs sorted (or at least...

awk '{printf("%d:",NR);len=0;for(i=1;i!=NF;++i){len+=length($i)+1;printf("%d ",len)}printf("\n")}' FS="?" infile

or

awk '{printf("%d:",NR)}{for(i=1;i<=NF;++i)if($i == "?")printf("%d...

See if this works:
awk 'NR>1{p=$0;sub($1 ORS,x,p);sub(ORS,x,p); print RS $1 ORS substr(p, 4921,6534-4921+1)}' RS=\> OFS= infile

Howdy!

Need to sort a large .txt file containing the following, using sort. First based on the 1st column, and then on the 2nd column:

Group01.01 1000500 31 0.913 -1.522974494...