10-24-2014
Do you have to use join cant you use awk for processing this...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
Could anyone help me ?
I'm trying to join two files, but no common field are on them. So I think on generate \000\ sequence to add for each line on both files, so then will be able to join these files.
Any idea?
Thanks in advance, (2 Replies)
Discussion started by: Manu
2 Replies
2. Shell Programming and Scripting
Hello!
I am very new to Linux and I do not know where to begin...
I have a column with >64,000 elements (that are not in numberical order) like this:
name
2
5
9
.
.
.
64,000
I would like to transpose this column into a row that will later become the header of a very large file... (2 Replies)
Discussion started by: doobedoo
2 Replies
3. Shell Programming and Scripting
Hello, i have a few questions which i hope you guys can address. the 1st prob:
The database i am using is a text file which displays the information like this :
Title : Quantity : Price
Persia : 30 : 20
... (5 Replies)
Discussion started by: gregarion
5 Replies
4. Shell Programming and Scripting
Hi All,
I need the command to join 2 lines into one. I found lots of threads but none give me the sollution. Probably because unix scripting is one of my best features ;)
I got a logfile where line 2 needs to be joined with line 1, lines 4 needs to be joined with line 3 etc
If you need... (16 Replies)
Discussion started by: rene21976
16 Replies
5. Shell Programming and Scripting
To give you some context of my issue the following is some sample dummy data. The field delimiter is "<-->". The 4th field is going to be tags for my notes. The tags should always be unique and sorted alphabetically.
1<-->01/20/12<-->01/20/12<-->1st note<-->1st note<-NL->2 lines... (4 Replies)
Discussion started by: adamreiswig
4 Replies
6. Shell Programming and Scripting
I do have many files of the following format.
File_1.txt
1 24
2 25
3 27
4 28
5 29
6 1
File_2.txt
2 5
3 8
4 9
5 10
File_3.txt (3 Replies)
Discussion started by: Lucky Ali
3 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I'm having some trouble joining these two files for some reason. Here is what they look like:
head *
I'm using:
join -a 1 -1 2 -2 1 f1 f2 -t, > joinfile.out
but unfortunately nothing is happening. I did notice that I was having trouble sorting f1 and I'm not sure why using:... (6 Replies)
Discussion started by: verse123
6 Replies
8. Shell Programming and Scripting
Hello masters,
Please help on the following.
I have a tab delimited file with subfields space delimited.
1 a b x y hhghd ghgf
2 v t f g gdgdgdg hghg
I have 3 lookup table files tab delimited, for fields 2,3 and 4 respectively
Lookup2
a 10
b 20
v 30
t 40
Lookup3 (12 Replies)
Discussion started by: ritakadm
12 Replies
9. Shell Programming and Scripting
hello gurus,
Somebody must have done this before, I couldn't find anything. Please redirect me if this was solved before, and if not please help.
To the problem now, I have multiple csv files (about 1000) which I need to concatenate by column header. The final file should have a superset... (4 Replies)
Discussion started by: abh.kumar
4 Replies
10. Shell Programming and Scripting
Hello,
I have 2 csv as follows:
a.csv:
name,phone,adress,car
xy,1234,asbd
yz,2134,asbdf
tc,6789,salkdur
b.csv:
telphone,vehicle
2134,toyota
6789,bmw
1234,honda
What is need is this:
output.csv:
name,phone,adres,car
xy,1234,asbd,honda
yz,2134,asbdf,toyota (7 Replies)
Discussion started by: Zam_1234
7 Replies
IGAWK(1) Utility Commands IGAWK(1)
NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO
gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
Free Software Foundation Nov 3 1999 IGAWK(1)