03-18-2015
thanks zaxxon & rudic, both works.
nope, sure not a homework for me at least. i am new to awk and i feel i really need to sit down and learn the basics. thanks again.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need help in file comparision.
I have two files in below format:
FILE_A:
-------
COL1 COL2 COL3 COL4 COL5
FILE_B:
-------
COL1A COL1B COL1C COL1D COL1E
i want to compare for a for each row in FILE_A and FILE_B
COL1 of FILE_A with COL1B of FILE_B
COL3 of FILE_A with COL1E of... (1 Reply)
Discussion started by: learnoutmore99
1 Replies
2. Shell Programming and Scripting
Hi Guys. I have tried the commands sort and join. But I couldn't able to to find the command for joining in a single line based on keys.My example inputs and outputs are like the following.
Help would be appreciated.:D
Input file
a1tabXXXXXXX
a2tabXXXXXXX
a6tabYYYYYYYYY
a71tabXXXXXXX... (7 Replies)
Discussion started by: repinementer
7 Replies
3. Shell Programming and Scripting
Hi,
I am new to unix and would greatly appreciate some help.
I have a file containing multiple colums containing different sets of data e.g.
File 1:
John Ireland 27_December_69
Mary England 13_March_55
Mike France 02_June_80
I am currently using the awk... (10 Replies)
Discussion started by: crunchie
10 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
i have a excel sheet with two columns as below.
column1 column2
100 100
200 300
300 400
400 400
500 600
i need to compare the values these two columns and the output should be printed in the third column...if these values are equal the output should be green and if these... (2 Replies)
Discussion started by: arunmanas
2 Replies
5. Shell Programming and Scripting
Dear everyone,
I need any sort of shell script or perl script would do the following. I have a txt file as follows:
;Stretnumber Resident Resdient (not in file)
16 John Mary
16 Mary Parker
16 Nancy Smith
16 Mary John
18 Trey ... (5 Replies)
Discussion started by: sasharma
5 Replies
6. Shell Programming and Scripting
Hi,
I have a large file with 100,000+ lines. Each line have a single value.
How do I effiecntly format the text to be X number of commas spaced fields in width.
i.e how do i turn this input:
26
53
79
80
81
82
111
131
135
139
192
193
198
199
203
209 (2 Replies)
Discussion started by: carlr
2 Replies
7. Shell Programming and Scripting
Hi friends
please help me on below,
i have 5 files like below
file1 is
x 10
y 20
z 15
file2 is
x 100
z 245
file3 is
y 78
z 23
file4 is
x 100 (3 Replies)
Discussion started by: siva kumar
3 Replies
8. Shell Programming and Scripting
Hi,
I have 3 files with one column value as shown
File: a.txt
------------
Data_a1
Data_a2
File2: b.txt
------------
Data_b1
Data_b2
Data_b3
Data_b4
File3: c.txt
------------
Data_c1
Data_c2
Data_c3
Data_c4
Data_c5 (6 Replies)
Discussion started by: vfrg
6 Replies
9. Shell Programming and Scripting
Hello guys, I am quite new to Shell Scripting and I need help for this
I have a CSV file like this:
Requisition,Order,RequisitionLineNumber,OrderLineNumber
REQ1,Order1,1,1
REQ1,Order1,1,3
REQ2,Order2,1,5
Basically what I want to do is compare the first 3 fields
If all 3 fields are the same... (5 Replies)
Discussion started by: jeffreybsu
5 Replies
10. Shell Programming and Scripting
Hi All,
Need to compare two date columns from the filname FinalDate.txt. My data's are like below
D_OT_START D_EXP_STR Amount
1/3/2012 1/3/2012 5000
6/21/2011 6/25/2011 6000
2/28/2011 2/28/2011 7000
7/16/2010 8/16/2010 8000
7/14/2010 10/26/2010 9000
... (3 Replies)
Discussion started by: suresh_target
3 Replies
TABS(1) BSD General Commands Manual TABS(1)
NAME
tabs -- set terminal tabs
SYNOPSIS
tabs [-n|-a|-a2|-c|-c2|-c3|-f|-p|-s|-u] [+m[n]] [-T type]
tabs [-T type] [+[n]] n1[,n2,...]
DESCRIPTION
The tabs utility displays a series of characters that first clears the hardware terminal tab settings and then initializes the tab stops at
the specified positions and optionally adjusts the margin.
The phrase "tab-stop position N" means that, from the start of a line of output, tabbing to position N shall cause the next character output
to be in the (N+1)th column on that line.
The following options are supported:
-n Specifies repetitive tab stops separated by a uniform number of columns, n, where n is a single digit decimal number. The
default usage of tabs with no arguments is equivalent to tabs -8. When -0 is used, the tab stops are cleared and no new ones
set.
-a Assembler, applicable to some mainframes. Equivalent to tabs 1,10,16,36,72 .
-a2 Assembler, applicable to some mainframes. Equivalent to tabs 1,10,16,40,72
-c COBOL, normal format. Equivalent to tabs 1,8,12,16,20,55
-c2 COBOL, compact format (columns 1 to 6 omitted). Equivalent to tabs 1,6,10,14,49
-c3 COBOL, compact format (columns 1 to 6 omitted), with more tabs than -c2. Equivalent to tabs
1,6,10,14,18,22,26,30,34,38,42,46,50,54,58,62,67
-f FORTRAN. Equivalent to tabs 1,7,11,15,19,23
-p PL/1. Equivalent to tabs 1,5,9,13,17,21,25,29,33,37,41,45,49,53,57,61
-s SNOBOL. Equivalent to tabs 1,10,55
-T type Indicates the type of terminal.
-u Assembler, applicable to some mainframes. Equivalent to tabs 1,12,20,44
EXIT STATUS
The tabs utility exits 0 on success, and >0 if an error occurs.
ENVIRONMENT
The COLUMNS and TERM environment variables affect the execution of tabs as described in environ(7).
The -T option overrides TERM. If neither TERM nor the -T option are present, tabs will fail.
SEE ALSO
expand(1), stty(1), tput(1), unexpand(1), termcap(5)
STANDARDS
The tabs utility conforms to IEEE Std 1003.1 (``POSIX.1'').
HISTORY
A tabs utility first appeared in PWB UNIX. This implementation was introduced in NetBSD 6.0.
AUTHORS
Roy Marples <roy@NetBSD.org>
BUGS
The current termcap(5) database does not define the set left soft margin 'ML' capability for any terminals.
BSD
December 9, 2008 BSD