Search Results

Thanks balajsuri,
That working, but I need to write the output in another file. How can I do that?
Thanks

How to sort a tab delimited file first on col1 and then on col2. Also I need to keep the header intact.

file.txt

val1 val2 val3 val4
a b c d
m n ...

Thanks a lot. Worked for me.

Thanks
The redirection to output file is not working as header is not printed in the outputfile.

Worked fine for me.
Thanks

Thanks bartus11,
How to change the field name? because with this code, the field name is not as the desired.
Thanks

Hi
In a tab delimited file how can I add a column that have values concatenated from all columns.
For example
input.txt

test1 test2 test3
zz2 mm uu
pp3 yy kk
ss2 tt ll
zz3 mm uu...

Thanks jim.

Input file
$ cat file.txt
test1 test2 test3
11 22 33
22 23 66
99 24 44
12 25 34
11 23 67

output file

test1 test2 test3 newCol
11 22 33 *
22 23 66 *
99 24 44 *...

Thanks for reply.

how to add header in the added column

I have a file having the following entries:

test1 test2 test3
11 22 33
22 44 66
99 99 44
---

I want to add a column so that the above file becomes:
test1 test2 test3...

Hi binlib.
Thanks for your help.

I am not sure if u also work with php or not. but this is very simple code that execute the above 'awk' command.

My php file (index.php) has just two...

Thanks for reply.

I wrote a php code that creates the following command:

join -t$'\t' -a1 -a2 -e- -j1 -o0,1.2,2.2 <(awk -f agg.awk fff1.txt) <(awk -f agg.awk fff2.txt) |
join -t$'\t' -a1...

I have variable number of files and I want to perform aggregate on each file and then combine. The related thread by me is on the following address. ...

I tried system() command also but not working .

I want to run awk from php to do some text processing. I am giving an extremely simple example below:


onecol.awk file
-------------------

{
print "Hello!";
}

f1.txt
---------
aaa
ccc...

This code is incredible.
This works exactly what i wanted. Awesome.
Can you please explain the switches you used here especially join. Also if I have variable number of input files then how can I...

I have different number of lines in each file and the output I need is not as straight forward.

Hi
I have multiple files each with two columns and I need to combine all those file into a tab delimited file. (multiple entry with same name separated by a comma)

The content of the files are...

Worked for me
Thanks a lot

Hi
I have two tab delimited file with different number of columns but same number of rows. I need to combine these two files in such a way that row 1 in file 2 comes adjacent to row 1 in file 1. ...