11-12-2010
Filtering issues with multiple columns in a single file
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 command to filter the first 2 columns to one file and the third column to another file e.g.
File 1:
John Ireland
Mary England
Mike France
File 2:
December
March
June
I then use the "paste" command to merge the data from both files so i get the following:
File 3:
John Ireland December
Mary England march
Mike France June
Is there a way to filter all the data to a single file and not to 2 seperate files. I am thinking of using the sed command but im not too sure.
If ive made anything unclear please reply and ill try to explain it better.
Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a requirement to filter multiple entries in a text file.
Entries are a pair of 2 lines .Like
line1
line2
.......
........
Here line1, line2 consist of one pair. line1 and line2 contain different data.
There can be multiple entries for the same pair. And there can be 'n' such... (2 Replies)
Discussion started by: suman_jakkula
2 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I have a single column of data that I would like to cut/print (with awk or ...) into multiple columns at every empty row (or common character).
Input:
5.99123
5.94693
7.21383
5.95202
0.907935
5.99149
6.08427
0.975774
6.077
Output:
5.99123 5.95202 6.08427
5.94693... (7 Replies)
Discussion started by: agibbs
7 Replies
3. Shell Programming and Scripting
Hi -
I'm new to the awk programming language. I'm trying to print a single column of data to several columns, and I found an article on iTWorld.com (ITworld.com - Printing in columns). It looks like the mkCols2 script is very close to what I need to do, but it looks like the end of the code... (2 Replies)
Discussion started by: astroDave
2 Replies
4. Shell Programming and Scripting
Hi,
I am currently filtering a file, "BUILD_TIMES", that has multiple column of information in it. An example of the data is as follows;
Fri Nov 5 15:31:33 2010 00:28:17 R7_BCGNOFJ_70.68
Fri Nov 5 20:57:41 2010 00:07:21 R7_ADJCEL_80.6
Wed Nov 10 17:33:21 2010 00:01:13 R7_BCTTEST3_80.1X... (7 Replies)
Discussion started by: crunchie
7 Replies
5. Shell Programming and Scripting
I have this input:
10 22 1 100
11 22 10 1 50
14 3 1 100
23 3 1 100
24 15 1 100
10 22 5 3 1 33.333
11 22 1 100
It has an inconsistent number of fields but the last field is determined by 100/(NF-2) using awk.
I want to take this multiple columned input file and transform so that... (2 Replies)
Discussion started by: mdlloyd7
2 Replies
6. Shell Programming and Scripting
Hi,
Input
7488 7389 chr1.fa chr1.fa
3546 9887 chr5.fa chr9.fa
7387 7898 chrX.fa chr3.fa
7488 7389 chr21.fa chr3.fa
7488 7389 chr1.fa chr1.fa
3546 9887 chr9.fa chr5.fa
7898 7387 chrX.fa chr3.fa
Desired Output
7488 7389 chr1.fa chr1.fa 2
3546 9887 chr5.fa chr9.fa 2... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
7. Shell Programming and Scripting
Hi Guys,
I am prety new to the hell scripting world. I am running some grep/cut commands and extracting from a csv file into a list. But the final product I need is that the whole list that I now have has to be broken and separated into columns.
Say what I now have extracted is a list of... (6 Replies)
Discussion started by: h_rishi
6 Replies
8. Shell Programming and Scripting
Hi friends,
I have one file like below. (.csv type)
SNo,data1,data2
1,1,2
2,2,3
3,3,2
and another file like below.
Exclude
data1
where Exclude should be treated as column name in file2.
I want the output shown below.
SNo,data2
1,2
2,3
3,2
Where my data1 column got removed from... (2 Replies)
Discussion started by: ks_reddy
2 Replies
9. 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
10. 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
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 clear the hardware terminal tab settings then initialises tab stops at specified posi-
tions, and optionally adjusts the margin.
In the first synopsis form, the tab stops set depend on the command line options used, and may be one of the predefined formats or at regular
intervals.
In the second synopsis form, tab stops are set at positions n1, n2, etc. If a position is preceded by a '+', it is relative to the previous
position set. No more than 20 positions may be specified.
If no tab stops are specified, the ``standard'' UNIX tab width of 8 is used.
The options are as follows:
-n Set a tab stop every n columns. If n is 0, the tab stops are cleared but no new ones are set.
-a Assembler format (columns 1, 10, 16, 36, 72).
-a2 Assembler format (columns 1, 10, 16, 40, 72).
-c COBOL normal format (columns 1, 8, 12, 16, 20, 55)
-c2 COBOL compact format (columns 1, 6, 10, 14, 49)
-c3 COBOL compact format (columns 1, 6, 10, 14, 18, 22, 26, 30, 34, 38, 42, 46, 50, 54, 58, 62, 67).
-f FORTRAN format (columns 1, 7, 11, 15, 19, 23).
-p PL/1 format (columns 1, 5, 9, 13, 17, 21, 25, 29, 33, 37, 41, 45, 49, 53, 57, 61).
-s SNOBOL format (columns 1, 10, 55).
-u Assembler format (columns 1, 12, 20, 44).
+m[n], +[n]
Set an n character left margin, or 10 if n is omitted.
-T type
Output escape sequence for the terminal type type.
ENVIRONMENT
The LANG, LC_ALL, LC_CTYPE and TERM environment variables affect the execution of tabs as described in environ(7).
The -T option overrides the setting of the TERM environment variable. If neither TERM nor the -T option are present, tabs will fail.
EXIT STATUS
The tabs utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
expand(1), stty(1), tput(1), unexpand(1), termcap(5)
STANDARDS
The tabs utility conforms to IEEE Std 1003.1-2001 (``POSIX.1'').
HISTORY
A tabs utility appeared in PWB UNIX. This implementation was introduced in FreeBSD 5.0.
BUGS
The current termcap(5) database does not define the 'ML' (set left soft margin) capability for any terminals.
BSD
May 20, 2002 BSD