Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Getting the lines with nth column non-null Post 302966193 by drl on Tuesday 9th of February 2016 08:39:21 AM
Old 02-09-2016
Hi.

On some instances of Solaris, one might find gawk:
Code:
OS, ker|rel, machine: SunOS, 5.11, i86pc
Distribution        : Solaris 11.2 X86
gawk GNU Awk 3.1.8

Best wishes ... cheers, drl
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to check Null values in a file column by column if columns are Not NULLs

Hi All, I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Discussion started by: Mandab
7 Replies

2. Shell Programming and Scripting

Editing 1st or nth column

Hi, I have a file whick is pipe delimited : 100| alpha| tabgo|watch| |||| 444444 | alpha| tabgo|watch| |||| 444444 | sweden |tabgo|watch| |||| 444444 | US| tabgo|watch| |||| 444444 100| factory| tabgo|watch| |||| 444444 | ABC| tabgo|watch| |||| 444444 | launch| tabgo|watch| ||||... (4 Replies)
Discussion started by: darshanw
4 Replies

3. Shell Programming and Scripting

get 3rd column of nth line

hi; i have a file.txt and its 9th, 10th and 11th line lines are: RbsLocalCell=S2C1 maxPortIP 4 (this is 9th line) RbsLocalCell=S3C1 maxPortIP 4 (this is 10th line) RbsLocalCell=S1C1 ... (11 Replies)
Discussion started by: gc_sw
11 Replies

4. Shell Programming and Scripting

Finding Nth Column

Please help me how can I display every nth field present in a "|" delimited file. Ex: If a have a file with data as a|b|c|d|e|f|g|h|k|l|m|n I want to display every 3rd feild which means the output should be c f k n Please help me. (1 Reply)
Discussion started by: ngkumar
1 Replies

5. Shell Programming and Scripting

Using AWK to find top Nth values in Nth column

I have an awk script to find the maximum value of the 2nd column of a 2 column datafile, but I need to find the top 5 maximum values of the 2nd column. Here is the script that works for the maximum value. awk 'BEGIN { subjectmax=$1 ; max=0} $2 >= max {subjectmax=$1 ; max=$2} END {print... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

6. Shell Programming and Scripting

Calculating average for every Nth line in the Nth column

Is there an awk script that can easily perform the following operation? I have a data file that is in the format of 1944-12,5.6 1945-01,9.8 1945-02,6.7 1945-03,9.3 1945-04,5.9 1945-05,0.7 1945-06,0.0 1945-07,0.0 1945-08,0.0 1945-09,0.0 1945-10,0.2 1945-11,10.5 1945-12,22.3... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

7. Shell Programming and Scripting

Find for line with not null values at nth place in pipe delimited file

Hi, I am trying to find the lines in a pipe delimited file where 11th column has not null values. Any help is appreciated. Need help asap please. thanks in advance. (3 Replies)
Discussion started by: manikms
3 Replies

8. Shell Programming and Scripting

How to remove mth and nth column from a file?

Hi, i need to remove mth and nth column from a csv file. here m and n is not a specific number. it is a variable ex. m=2 n=5 now i need to remove the 2nd and 5th line.. Please help how to do that. Thanks!!! (18 Replies)
Discussion started by: zaq1xsw2
18 Replies

9. Shell Programming and Scripting

Break Column nth in a CSV file into two

Hi Guys, Need help with logic to break Column nth in a CSV file into two for e.g Refer below the second column as the nth column "abcd","","type/beta-version" need output in a following format "abcd","/place/asia/india/mumbai","/product/sw/tomcat","type/beta-version" ... (5 Replies)
Discussion started by: awk-admirer
5 Replies

10. Shell Programming and Scripting

Taking nth column and putting its value in n+1 column using awk

Hello Members, Need your expert opinion how to tackle below. I have an input file that looks like below: USS|AWCC|AFGAW|93|70 USSAA|Roshan TDCA|AFGTD|93|72,79 ALB|Vodafone|ALBVF|355|69 ALGEE|Wataniya (Nedjma)|DZAWT|213|50,550 I like output file in below format: ... (7 Replies)
Discussion started by: umarsatti
7 Replies
REARJ(1)							   Arj Software 							  REARJ(1)

NAME
rearj - Converts other archive formats to .arj files SYNOPSIS
rearj [options] <!listfile(s)|filespec(s)|wildname(s)> DESCRIPTION
The rearj command can repackage other archive formats to arj. OPTIONS
-+ Ignore REARJ_SW variable. -a[suffix] Convert archives within archives ("*" for all formats). -bcommand Execute command before extracting files. -ccommand Execute command on extracted files before counting them. -d Delete original archives. -e No error switch. -f Convert diskette archives. -g Skip creation of output archive. -i[name] Check integrity of rearj program. -j Skip if output archive size is larger than the original. -k Skip archive timestamping. -l[name] Write append log file (default name is rearj.log). -m[date] Select archives before date in YYMMDDHHMMSS format. -n[date] Select archives on or after date in YYMMDDHHMMSS format. -o Allow overwrite of existing target archive. -p Ignore long filenames under Windows 95. -q Query for each archive to convert. -r Recurse through subdirectories. -s Skip verify of file count and total size. -tsuffix Create suffix type archives. -u[bak] Allow update of archive with backup (default is BAK). -v Execute configured command on extracted files. -wdir Assign work directory. -x[!]file Exclude by filename, wildname, or listfile. -y[text] Delete output archive and write text to log (testing mode). -z Simulate operation. ENVIRONMENT
REARJ_SW If set, its value will be used as command line options. EXIT STATUS
0 Success. 1 File not found. 2 File is not a configured archive type. 3 Target archive already exists. 4 Not enough disk space. 5 User skipped or user did not select update option. 6 UNPACK command error. 7 PACK command error. 8 Target cannot support directories. 9 Wrong file count. 10 Wrong total size. 11 Internal archive REARJ error. 12 Rename archive error. 13 Invoked -v command error (found a virus?). 14 Output archive is larger. EXAMPLE
rearj * -r -d Convert all archives to ARJ format, searching all subdirectories, deleting original archives. SEE ALSO
arj(1). AUTHOR
This manual page was written by Ola Lundqvist <opal@debian.org> in pod format, then converted by Guillem Jover <guillem@debian.org> to nroff format. 3.10 2003-03-10 REARJ(1)
All times are GMT -4. The time now is 03:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy