10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I have a large data file, want to separate it into 100 part and export one specific field as a file; then I want to append each part's column into one file. How to realize that?
1 2 3 1
2 3 4 2
2 3 4 3
3 3 4 4
3 4 5 5
3 4 5 6
I want the last column of the data file, e.g divide it... (5 Replies)
Discussion started by: wanliushao
5 Replies
2. Shell Programming and Scripting
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies
3. Shell Programming and Scripting
Hello everyone,
I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble.
I have many files each having two columns and hundreds of rows.
first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Discussion started by: isildur1234
5 Replies
4. UNIX for Dummies Questions & Answers
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
pp23 yy kk
ss3 tt ll
11e 22 44
33c 22 99
output.txt
test1 test2 test3 reslt (6 Replies)
Discussion started by: mary271
6 Replies
5. Shell Programming and Scripting
Hi i have a file with follw data
"20090427","0","","16371311","-100200","","","","16371311","JUL","09"
In the 10th column i need to convert the month name into month number in this case JUL will be 7 and append the 10th and 11th column which shows me the output as 709. Can you suggest a shell... (11 Replies)
Discussion started by: vee789
11 Replies
6. Shell Programming and Scripting
Hi,
I have a requirement where I need to append the runtimes of the jobs for every run.
I have some 100 jobname and it will be static in output(1st column) . Everyday I need to run my script to find the runtimes for that day and add the entire 100 runtimes to the right of those 100 jobs(2nd... (19 Replies)
Discussion started by: ajayakunuri
19 Replies
7. Shell Programming and Scripting
I like to do the following, please help! Thanks a lot
for f in seq(f1 f2 f3 g1 h1 t2)
do
cut -d "+" -f2 $f > $f.nums
paste ? # each loop will attach additional column to the created file $f.nums, how to do this???
done (1 Reply)
Discussion started by: ksgreen
1 Replies
8. Shell Programming and Scripting
Hi All, can you help me with this:
grep XXX dir/*.txt|wc -l > newfile.txt - this put the results in the newfile.txt, but I want to add another column in the newfile.txt, string 'YYYYY', separated somehow, which corresponds on the grep results?
For example grep will grep XXX dir/*.txt|wc -l >... (5 Replies)
Discussion started by: apenkov
5 Replies
9. Programming
I have to files
File1
1 23
2 34
3 7
4 56
5 61
6 22
7 65
File2
2 21
4 32
7 22
Now i need to compare column1 of both the files and generate a third file which should contain all the values of 1st column of 1st file and in the second column i need to get the coressponding row... (2 Replies)
Discussion started by: kamuju
2 Replies
10. Shell Programming and Scripting
Hi
Having a file as follows
file1.txt
Date (dd/mm)Time Server IP Error Code
===========================================================================
10/04/2008 10:10 ServerA xxx.xxx.xxx.xxx 6
10/04/2008 10:10 ServerB ... (3 Replies)
Discussion started by: karthikn7974
3 Replies