10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I have requirement where multiple csv files are present in a directory and each file contains a header.I need to append the contents of all the files into one file by removing header.
Once the data is merged in one file ,I need to remove duplicates on nth column to find out distinct... (2 Replies)
Discussion started by: STCET22
2 Replies
2. UNIX for Dummies Questions & Answers
I am trying to append multiple files in a directory
cat /a/file1.txt /a/file2.txt /a/file3.txt /a/file4.txt > /a/file.txt
Except file2 every other file is appending.
I interchanged file names and ran the command. Whatever file repeating in the second position is missing in output... (6 Replies)
Discussion started by: eskay
6 Replies
3. Shell Programming and Scripting
Hi, I'm trying to use awk arrays to compare values across two files based on multiple columns. I've attempted to load file 2 into an array and compare with values in file 1, but success has been absent. If anyone has any suggestions (and I'm not even sure if my script so far is on the right lines)... (4 Replies)
Discussion started by: hubleo
4 Replies
4. Shell Programming and Scripting
So I have a space delimited file that I'd like to split into multiple files based on multiple column values.
This is what my data looks like
1bc9A02 1 10 1000 FTDLNLVQALRQFLWSFRLPGEAQKIDRMMEAFAQRYCQCNNGVFQSTDTCYVLSFAIIMLNTSLHNPNVKDKPTVERFIAMNRGINDGGDLPEELLRNLYESIKNEPFKIPELEHHHHHH
1ku1A02 1 10... (9 Replies)
Discussion started by: viored
9 Replies
5. UNIX for Dummies Questions & Answers
Hi ,
I have the below ouput,
=====gopi=====
assasassaa
adsadsadsdsada
asdsadsadasdsa
sadasdsadsd
=====kannan===
asdasdasd
sadasddsaasd
adasdd
=====hbk===
asasasssa
....
..
I want the output like as below, not able paste here correctly. (2 Replies)
Discussion started by: eeegopikannan
2 Replies
6. Shell Programming and Scripting
Hi,
I am using ksh, I want to read one csv file and append the columns of another file with new column.
My input file:
col1,col2
---------
siri,886
satya,890
priya,850
Another file with the below date:(test.csv)
col3
-----
321
333
442 (1 Reply)
Discussion started by: siri_886
1 Replies
7. 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
8. 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
9. Shell Programming and Scripting
Hello,
I am trying to solve for a couple of hours now the following problem:
I have n files and would like to add the third column of each file to a new file:
temp1.txt
1 2 3
1 2 3
1 2 3
temp2.txt
1 2 4
1 2 4
1 2 4
1 2 4
temp3.txt (2 Replies)
Discussion started by: creamcheese
2 Replies
10. Shell Programming and Scripting
Hi all,
I have three files, one is a navigation file, one is a depth file and one is a file containing the measured field of gravity. The formats of the files are;
navigation file:
2006 320 17 39 0 0 *nav 21.31542 -157.887
2006 320 17 39 10 0 *nav 21.31542 -157.887
2006 320 17 39 20 0... (2 Replies)
Discussion started by: andrealphus
2 Replies