Sponsored Content
Top Forums UNIX for Beginners Questions & Answers awk to print percent based on vales in file Post 303044712 by cmccabe on Monday 2nd of March 2020 08:28:18 AM
Old 03-02-2020
Thank you very much Smilie.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find percent between sum of 2 columns awk help

Hi I'm new to this forum and I'm a beginner when it comes to shell and awk programming. But I have the following problem: I have 5 csv files (data1.csv, data2.csv, etc.) and need to calculate the average between the total sum of the 1st and 7 column. csv example:... (3 Replies)
Discussion started by: sapo51
3 Replies

2. Shell Programming and Scripting

awk help - input vales from on efile to annother

Please see attached test file for better explanation and formatting of files....thanks foo1 H2600 LINE: H2600 H2600 H2600 MYSystems Ltd. (Feb 18 2009) V1760R1130 1 2213133522.79N 81 027.09E 500814.01502345.9 145 9 837 E1760R1130 1 2 2213133522.44N 81 027.33E... (4 Replies)
Discussion started by: garethsays
4 Replies

3. Shell Programming and Scripting

awk if percent % checking

hi everyone, # cat a a 10% b 25.5% c 91% d 50% # cat a | awk '$2 >= 90%; END {print $_}' awk: $2 > 90%; END {print $_} awk: ^ syntax error awk: each rule must have a pattern or an action part how to do only print when 2nd coln >= 90%. Thanks (6 Replies)
Discussion started by: jimmy_y
6 Replies

4. Shell Programming and Scripting

awk print non matching lines based on column

My item was not answered on previous thread as code given did not work I wanted to print records from file2 where comparing column 1 and 16 for both files find rows where column 16 in file 1 does not match column 16 in file 2 Here was CODE give to issue ~/unix.com$ cat f1... (0 Replies)
Discussion started by: sigh2010
0 Replies

5. Shell Programming and Scripting

awk based script to print the "mode(statistics term)" for each column in a data file

Hi All, Thanks all for the continued support so far. Today, I need to find the most occurring string/number(also called mode in statistics terminology) for each column in a data file (.csv type). For one column of data(1.txt) like below Sample 1 2 2 3 4 1 1 1 2 I can find the mode... (6 Replies)
Discussion started by: ks_reddy
6 Replies

6. Shell Programming and Scripting

print the whole row in awk based on matched pattern

Hi, I need some help on how to print the whole data for unmatched pattern. i have 2 different files that need to be checked and print out the unmatched patterns into a new file. My sample data as follows:- File1.txt Id Num Activity Class Type 309 1.1 ... (5 Replies)
Discussion started by: redse171
5 Replies

7. Shell Programming and Scripting

awk to print specific line in file based on criteria

In the file below I am trying to extract a specific instance of path, if the adjacent plugin": "/rundb/api/v1/plugin/49/. Thank you :). file "path": "/results/analysis/output/Home/Auto_user_S5-00580-4-Medexome_65_028/plugin_out/FileExporter_out.52", "plugin": "/rundb/api/v1/plugin/49/",... (8 Replies)
Discussion started by: cmccabe
8 Replies

8. Shell Programming and Scripting

awk to calculate total and percent off field in file

Trying to use awk to print the lines in file that have either REF or SNV in $3, add a header line, sort by $4 in numerical order. The below code does that already, but where I am stuck is on the last part where the total lines are counted and printed under Total_Targets, under Targets_less_than is... (4 Replies)
Discussion started by: cmccabe
4 Replies

9. Shell Programming and Scripting

awk to print line based on two keywords

I am starting to write a multi-line awk and using the file below which is tab-delimited, print only the line with oncomineGeneClass and oncomineVariantClass and PASS. The script execute but seems to be printing the entire file, not the desired line. Thank you :). file ... (8 Replies)
Discussion started by: cmccabe
8 Replies

10. Shell Programming and Scripting

Using awk to print output based on first field.

Hi Folks, I have one requirement, There is one file, which contains two fields. Based on first field, I need to print an output. Example will be more suitable. Input file like this. abc 5 abc 10 xyz 6 xyz 9 xyz 10 mnp 10 mnp 12 mnp 6 (2 Replies)
Discussion started by: Raza Ali
2 Replies
cat(1)								   User Commands							    cat(1)

NAME
cat - concatenate and display files SYNOPSIS
/usr/bin/cat /usr/bin/cat [-nbsuvet] [file...] ksh93 cat [-bdenstuvABDEST] [file...] DESCRIPTION
/usr/bin/cat The cat utility reads each file in sequence and writes it on the standard output. Thus: example% cat file prints file on your terminal, and: example% cat file1 file2 >file3 concatenates file1 and file2, and writes the results in file3. If no input file is given, cat reads from the standard input file. ksh93 The cat built-in in ksh93 is associated with the /bin and /usr/bin paths. It is invoked when cat is executed without a pathname prefix and the pathname search finds a /bin/cat or /usr/bin/cat executable. cat copies each file in sequence to the standard output. If no file is specified, or if the file is -, cat copies from standard input starting at the current location. OPTIONS
/usr/bin/cat The following options are supported by /usr/bin/cat: -b Number the lines, as -n, but omit the line numbers from blank lines. -n Precede each line output with its line number. -s cat is silent about non-existent files. -u The output is not buffered. Buffered output is the default. -v Non-printing characters, with the exception of tabs, NEWLINEs and form feeds, are printed visibly. ASCII control characters (octal 000 - 037) are printed as ^n, where n is the corresponding ASCII character in the range octal 100 - 137 (@, A, B, C, . . ., X, Y, Z, [, , ], ^, and _); the DEL character (octal 0177) is printed ^?. Other non-printable characters are printed as M-x, where x is the ASCII character specified by the low-order seven bits. When used with the -v option, the following options can be used: -e A $ character is printed at the end of each line, prior to the NEWLINE. -t Tabs are printed as ^Is and form feeds to be printed as ^Ls. The -e and -t options are ignored if the -v option is not specified. ksh93 ksh93 cat supports the following options: -b --number-nonblank Number lines as with -n but omit line numbers from blank lines. -d --dos-input Open input files in text mode. Removes RETURNs in front of NEWLINEs on some systems. -e Equivalent to -vE. -n --number Insert a line number at the beginning of each line. -s Equivalent to -S for att universe and -B otherwise. -t Equivalent to -vT. -u --unbuffer Do not delay the output by buffering. -v --show-nonprinting Cause non-printing characters (with the exception of TABs, NEWLINEs, and form feeds) to be output as printable character sequences. ASCII control characters are printed as ^n, where n is the corresponding ASCII character in the range octal 100-137. The DEL character (octal 0177) is copied as ^?. Other non-printable characters are copied as M-x where x is the ASCII character specified by the low-order seven bits. Multi-byte characters in the current locale are treated as printable characters. -A --show-all Equivalent to -vET. -B --squeeze-blank Replace multiple adjacent NEWLINE characters with one NEWLINE. -D --dos-output Open output files in text mode. Insert RETURNs in front of NEWLINEs on some systems. -E --show-ends Insert a $ before each NEWLINE. -S --silent cat is silent about non-existent files. -T --show-blank Copies TABs as ^I and form feeds as ^L. OPERANDS
The following operand is supported: file A path name of an input file. If no file is specified, the standard input is used. If file is -, cat reads from the standard input at that point in the sequence. cat does not close and reopen standard input when it is referenced in this way, but accepts multiple occurrences of - as file. USAGE
See largefile(5) for the description of the behavior of cat when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes). EXAMPLES
Example 1 Concatenating a File The following command writes the contents of the file myfile to standard output: example% cat myfile Example 2 Concatenating Two files into One The following command concatenates the files doc1 and doc2 and writes the result to doc.all. example% cat doc1 doc2 > doc.all Example 3 Concatenating Two Arbitrary Pieces of Input with a Single Invocation When standard input is a terminal, the following command gets two arbitrary pieces of input from the terminal with a single invocation of cat: example% cat start - middle - end > file when standard input is a terminal, gets two arbitrary pieces of input from the terminal with a single invocation of cat. If standard input is a regular file, example% cat start - middle - end > file would be equivalent to the following command: cat start - middle /dev/null end > file because the entire contents of the file would be consumed by cat the first time - was used as a file operand and an end-of-file condition would be detected immediately when -was referenced the second time. ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of cat: LANG, LC_ALL, LC_CTYPE, LC_MES- SAGES, and NLSPATH. EXIT STATUS
The following exit values are returned: 0 All input files were output successfully. >0 An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: /usr/bin/cat +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ |CSI |Enabled | +-----------------------------+-----------------------------+ |Interface Stability |Committed | +-----------------------------+-----------------------------+ |Standard |See standards(5). | +-----------------------------+-----------------------------+ ksh93 +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ |Interface Stability |See below. | +-----------------------------+-----------------------------+ The ksh93 built-in binding to /bin and /usr/bin is Volatile. The built-in interfaces are Uncommitted. SEE ALSO
touch(1), attributes(5), environ(5), largefile(5), standards(5) NOTES
Redirecting the output of cat onto one of the files being read causes the loss of the data originally in the file being read. For example, example% cat filename1 filename2 > filename1 causes the original data in filename1 to be lost. SunOS 5.11 8 Apr 2008 cat(1)
All times are GMT -4. The time now is 09:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy