Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk incorrect format
Top Forums Shell Programming and Scripting awk incorrect format Post 303025262 by RudiC on Monday 29th of October 2018 06:12:57 PM
Old 10-29-2018
How about, hoping that any invisible surprises like the ones corona688 mentioned will have been taken care of, and untested, from a windows machine, so bear with me:


Code:
awk -F "\t" 'NR == FNR {REP[$3] = $4$5; next} REP[$1] == $4 {$3 = REP[$1]; gsub (/[^ACGT]/, "", $3); print}' OFS="\t" INPUT file2


BTW, if ($3 = $4) should read if ($3 == $4), but this would not explain the additional line feed that you complain about.
This User Gave Thanks to RudiC For This Post:
Geneanalyst
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file... (1 Reply)
Discussion started by: mdap
1 Replies

2. Shell Programming and Scripting

Awk incorrect data.

I am using the following command: nawk -F"," 'NR==FNR {a=$1;next} a {print a,$1,$2,$3}' file1 file2 I am getting 40 records output. But when i import file1 and file2 in MS Access i get 140 records. And i know 140 is correct count. Appreciate your help on correcting the above script (5 Replies)
Discussion started by: pinnacle
5 Replies

3. Shell Programming and Scripting

Merge lines in a file with Awk - incorrect output

Hi, I would like: FastEthernet0/0 is up, line protocol is up 0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored 0 output errors, 0 collisions, 0 interface resets Serial1/0:0 is up, line protocol is up 0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored, 0 abort 0... (14 Replies)
Discussion started by: mv652
14 Replies

4. Shell Programming and Scripting

awk to extract incorrect fixed length records

I have a number of unix text files containing fixed-length records (normal unix linefeed terminator) where I need to find odd records which are an incorrect length. The data is not validated and records can contain odd backslash characters and control characters which makes them awkward to process... (2 Replies)
Discussion started by: methyl
2 Replies

5. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

Hi Experts, I am adding a column of numbers with awk , however not getting correct output: # awk '{sum+=$1} END {print sum}' datafile 2.15291e+06 How can I getthe output like : 2152910 Thank you.. # awk '{sum+=$1} END {print sum}' datafile 2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies

6. Shell Programming and Scripting

awk : deleting specific incorrect lines

Hello friends, I searched in forums for similar threads but what I want is to have a single awk code to perform followings; I have a big log file going like this; ... 7450494 1724465 -47 003A98B710C0 7450492 1724461 -69 003A98B710C0 7450488 1724459 001DA1915B70 trafo_14:3 7450482... (5 Replies)
Discussion started by: enes71
5 Replies

7. Shell Programming and Scripting

wget format incorrect

I want to extract a web page to a temporary file as a source document. I tried: wget $webPgURL > /tmp/tmpfil but it says I have a missing URL. I have echoed $webPgURL just prior to the wget command and it is correct. If I use: firefox $webPbURL it brings up firefox with the correct page. Can... (3 Replies)
Discussion started by: slak0
3 Replies

8. Shell Programming and Scripting

awk sum giving incorrect value

cat T|awk -v format=$format '{ SUM += $1} END { printf format,SUM}' the file T has below data usghrt45tf:hrguat:/home/hrguat $ cat T -1363000.00123456789 -95000.00789456123 -986000.0045612378 -594000.0015978 -368939.54159753258415 -310259.0578945612 -133197.37123456789... (4 Replies)
Discussion started by: zulfi123786
4 Replies

9. Shell Programming and Scripting

Df -h | awk - output incorrect matching

Running solaris 9, on issuing the follwing command df -h | awk '$5 > 45 {print}' Filesystems with utilisation > 45% are being displayed as well as those between 5 and-9%!!! (3 Replies)
Discussion started by: squrcles
3 Replies

10. Shell Programming and Scripting

awk command gives incorrect result?

Hi All, I am looking to filter out filesystems which are greter than a specific value. I use the command df -h | awk '$4 >=70.00 {print $4,$5}' But this results out as below, which also gives for lower values. 9% /u01 86% /home 8% /u01/data 82% /install 70% /u01/app Looks... (3 Replies)
Discussion started by: jjoy
3 Replies

LEARN ABOUT DEBIAN

rep

REP(1)																	    REP(1)

NAME

       rep - Read, Eval, Print Interpreter

SYNOPSIS

       rep  [	FILE  ] [  --batch  ] [  --interp  ] [	-f, --call FUNCTION  ] [  -l, --load FUNCTION  ] [  -s, --scheme FILE  ] [  --version  ] [
       --no-rc	] [  -q, --quit  ]

DESCRIPTION

       rep `librep' is a dialect of Lisp, designed to be used both as an extension language for applications and as a general purpose  programming
       language.  It was originally written to be mostly-compatible with Emacs Lisp, but has subsequently diverged markedly. Its aim is to combine
       the best features of Scheme and Common Lisp and provide an environment that is comfortable for implementing both small and large scale sys-
       tems. It tries to be a "pragmatic" programming language.

OPTIONS

       FILE   load the Lisp file FILE (from the cwd if possible, implies --batch mode)

       --batch
	      Batch mode: process options and exit.

       --interp
	      Interpreted mode: don't load compile Lisp files.

       -f FUNCTION --call FUNCTION
	      Call the Lisp function FUNCTION.

       -l FILE --load FILE
	      Load the file of Lisp forms called FILE.

       -s FILE --scheme FILE
	      Load the file of Scheme forms called FILE (implies --batch mode).

       --version
	      Print version details.

       --no-rc
	      Don't load rc or site-init files.

       -q --quit
	      Terminate the interpreter process.

SEE ALSO

       The programs are documented fully by John Harper available via the Info system.

AUTHOR

       This manual page was written by Christian Marillat <marillat@debian.org> for the Debian GNU/Linux system (but may be used by others).

								   04 avril 2003							    REP(1)
All times are GMT -4. The time now is 06:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy