10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello All
I'm joining two files using Awk by Left outer join on the file 1
File 1
1 AA
2 BB
3 CC
4 DD
File 2
1 IND 100 200 300
2 AUS 400 500 600
5 USA 700 800 900 (18 Replies)
Discussion started by: venkat_reddy
18 Replies
2. Shell Programming and Scripting
I have a series of csv files in the following format
eg file1
Experiment Name,XYZ_07/28/15,
Specimen Name,Specimen_001,
Tube Name, Control,
Record Date,7/28/2015 14:50,
$OP,XYZYZ,
GUID,abc,
Population,#Events,%Parent
All Events,10500,
P1,10071,95.9
Early Apoptosis,1113,11.1
Late... (6 Replies)
Discussion started by: pawannoel
6 Replies
3. Shell Programming and Scripting
Hi,
I have multiple files that each contain one column of strings:
File1:
123abc
456def
789ghi
File2:
123abc
456def
891jkl
File3:
234mno
123abc
456def
In total I have 25 of these type of file. (5 Replies)
Discussion started by: owwow14
5 Replies
4. Shell Programming and Scripting
Hi, I need to create weekly files from daily records stored in individual monthly filenames from 1999-2010. my sample file structure is like the ones below:
daily record stored per month:
199901.xyz, 199902.xyz, 199903.xyz, 199904.xyz ...199912.xyz
records inside 199901.xyz (original data... (4 Replies)
Discussion started by: ida1215
4 Replies
5. Shell Programming and Scripting
hi everyone!
I'd like to extract a single column from 5 different files and put them together in an output file. I saw a similar question for 2 input files, and the line of code workd very well, the code is:
awk 'NR==FNR{a=$2; next} {print a, $2}' file1 file2
I added the file3, file4 and... (10 Replies)
Discussion started by: orcaja
10 Replies
6. UNIX for Dummies Questions & Answers
hi everyone!
I already posted it in scripts, I'm sorry, it's doubled
I'd like to extract a single column from 5 different files and put them together in an output file. I saw a similar question for 2 input files, and the line of code workd very well, the code is:
awk 'NR==FNR{a=$2; next}... (1 Reply)
Discussion started by: orcaja
1 Replies
7. Shell Programming and Scripting
Hello,
I have 2 files file1 & file2
=
a1 b1
a2 b2
a3 b3
...
=
c1 d1
c2 d2
c3 d3
...
I need to compare if b(i)=c(j) . i,j=1,2,3,4,...
If yes, right a(i) d(j) in output file3 per line (1 Reply)
Discussion started by: newpromo
1 Replies
8. 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
9. Shell Programming and Scripting
Hi,
Need to extract a string from one file and search the same in other files.
Ex:
I have file1 of hundred lines with no delimiters not even space.
I have 3 more files.
I should get 1 to 10 characters say substring from each line of file1 and search that string in rest of the files and get... (1 Reply)
Discussion started by: mohancrr
1 Replies
10. UNIX for Dummies Questions & Answers
Hello!
I wan't to extract columns from two files and later combine them for plotting with gnuplot. If the files file1 and file2 look like:
fiile1:
a, 0.62,x
b, 0.61,x
file2:
a, 0.43,x
b, 0,49,x
The desired output is
a 0.62 0.62
b 0.61 0.49
Thank you in advance! (2 Replies)
Discussion started by: kingkong
2 Replies