Help to get correct data using awk Post: 302726365

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Conversion of Exponential to numeric in awk- not correct output

Hi All, I have 1 million records file. Using awk, I am counting the number of records. But as the number is huge, after crossing a number, awk is displaying it in exponential format. At the end, I need to verify this count given by awk with expected count. But as it is in exponential format,...

2. Shell Programming and Scripting

AWK not giving me correct output.

i have a line like this in my script IP=`get_IP <hostname> | awk '{ print $1 }' echo $IP the problem is get_IP <hostname> returns data formated as follows: ip 1.1.1.1 name server_name the code above returns 1.1.1.1 server_name and i just need the 1.1.1.1 I have tried to add "|...

3. Shell Programming and Scripting

Awk error -- awk: 0602-562 Field $() is not correct.

typeset -i i=1 while read -r filename; do Splitfile=`$Targetfile_$i.txt` awk 'substr($0,1,5) == substr($filename,1,5) && substr($0,526,2) == substr($filename,6,2) && substr($0,750,12) == substr($filename,8,12)' $SourceFilename >> $Splitfile i=i+1 done < /tmp/list.out I am using this logic...

4. Shell Programming and Scripting

AWK or SED for correct columns

Hello, I have the following file, but one of his columns is not in place, and tried with SED and AWK, how I can correct format? In the second line break is wrong, and puts it after the first column of next line I would appreciate if you could guide me on the subject.

5. Shell Programming and Scripting

Using AWK to Calculate Correct Responses

Hello, I am trying to count how many times a subject makes a correct switch or a correct stay response in a simple task. I have data on which condition they were in (here, labeled "IMAGINE" and "RECALL"), as well as whether they made a left or right button response, and whether the outcome was...

6. Shell Programming and Scripting

Cannot get the correct ans. Using awk in taking average

Hi all, I think so I’m getting the result is wrong, while using following awk commend, colval=$(awk 'FNR>1 && NR==FNR{a=$4;next;} FNR>1 {a+=$4; print $2"\t"a/3}' filename_f.tsv filename_f2.tsv filename_f3.tsv) echo $colval >> Result.tsv it’s doing the condition 2 times, first result...

7. Shell Programming and Scripting

How to correct this awk code without eval?

Hi everyone, The following piece of awk code works fine if I use eval builtin var='$1,$2' ps | eval "awk '{print $var}'" But when I try to knock off eval and use awk variable as substitute then I am not getting the expected result ps | awk -v v1=$var '{print v1}' # output is $1,$2 ps |...

8. Shell Programming and Scripting

Shell script to correct the data

Hi, I have below data in my flat file.I would like to remove the quotes and comma necessary from the data.Below is the details I would like to have in my output. Could anybody help me providing the Unix shell script for this. Input : ABC,ABC,10/15/2012,"47,936,164.567 ","1,036,997.453...

9. Programming

Correct way to read data of different formats into same struct

I was wondering what is the correct way to read in data "one-part-per-line" as compared with "one-record-per-line" formats into the same structure in C? format1.dat: Zacker 244.00 244.00 542.00 Lee 265.00 265.00 456.00 Walter 235.00 235.00 212.00 Zena 323.00 215.45 ...

10. Shell Programming and Scripting

awk output is not the correct count

The awk below runs and produces the following output on the file2. This is just an example of the format as the file is ~14MB. file1.txt is attached. I am trying to count the ids that match between the two files and out the ids that are missing. Thank you :). file2 970 NM_213590 ...

LEARN ABOUT CENTOS

gtester

GTESTER(1)							   User Commands							GTESTER(1)

NAME

       gtester - test running utility

SYNOPSIS

       gtester [OPTION...] [testprogram]

DESCRIPTION

       gtester is a utility to run unit tests that have been written using the GLib test framework.

       When called with the -o option, gtester writes an XML report of the test results, which can be converted into HTML using the gtester-report
       utility.

OPTIONS

       -h, --help
	   print help and exit

       -v, --version
	   print version information and exit

       --g-fatal-warnings
	   make warnings fatal

       -k, --keep-going
	   continue running after tests failed

       -l
	   list paths of available test cases

       -m=MODE
	   run test cases in MODE, which can be one of:

	   perf
	       run performance tests

	   slow, thorough
	       run slow tests, or repeat non-deterministic tests more often

	   quick
	       do not run slow or performance tests, or do extra repeats of non-deterministic tests (default)

	   undefined
	       run test cases that deliberately provoke checks or assertion failures, if implemented (default)

	   no-undefined
	       do not run test cases that deliberately provoke checks or assertion failures

       -p=TESTPATH
	   only run test cases matching TESTPATH

       -s=TESTPATH
	   skip test cases matching TESTPATH

       --seed=SEEDSTRING
	   run all test cases with random number seed SEEDSTRING

       -o=LOGFILE
	   write the test log to LOGFILE

       -q, --quiet
	   suppress per test binary output

       --verbose
	   report success per testcase

SEE ALSO

       gtester-report(1)

GLib																	GTESTER(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Conversion of Exponential to numeric in awk- not correct output

Discussion started by: ssunda6

2. Shell Programming and Scripting

AWK not giving me correct output.

Discussion started by: mcdef

3. Shell Programming and Scripting

Awk error -- awk: 0602-562 Field $() is not correct.

Discussion started by: pukars4u

4. Shell Programming and Scripting

AWK or SED for correct columns

Discussion started by: nitwh