10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have requirement to split below file (sample.csv) into multiple files by using the unique columns (first 3 are unique columns)
123|12|5679|BCDEFG|34CD56|2019-07-10|2019-07-10|896.7200|1|2... (3 Replies)
Discussion started by: RVSP
2. Shell Programming and Scripting
I want to join 2 tabbed files on the first 2 fields, and filling the missing values with 0. The 3rd column in each file is constant for the entire file.
12658699 ST5 XX2720 0 1 0 1
53039541 ST5 XX2720 1 0 1.5 1
file2 ... (6 Replies)
Discussion started by: sheetalk
3. Shell Programming and Scripting
I have a one file called (file1) which the structure looks like this
In addition, I have around 300... (19 Replies)
Discussion started by: sajmar
4. Shell Programming and Scripting
Please help, I want to join multiple files based on column 1, and put the missing values as 0. Also the colname in the output should say which file the values came from.
FILE1 FILE2 FILE3
1 11 0 31 (1 Reply)
Discussion started by: newbie83
5. Shell Programming and Scripting
I am trying to join 24 files (i showed example of 3 files below). They all have 2 columns. The first columns is common to all. The files are tab delimited eg
rs0004 3.77e-10... (4 Replies)
Discussion started by: fat
6. UNIX for Dummies Questions & Answers
I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column).
I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
7. Shell Programming and Scripting
Is it possible to join all the files with input1 based on 1st column?
c (2 Replies)
Discussion started by: quincyjones
8. Shell Programming and Scripting
I have to split the incoming source file into multiple file.
File contains some unwanted XML tags also .
Files looks like
some XML tags
some xml tags
I have to ignore XML tags and only split file... (6 Replies)
Discussion started by: manish2608
9. Shell Programming and Scripting
I am trying to join a few hundred files using join. Is there a way to use while read or something else to automate this. My problem is the following.
Day 3 (3 Replies)
Discussion started by: theFinn
10. UNIX for Dummies Questions & Answers
My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns:
File A: (tab-delimited)
PDB CHAIN Start End Fragment
1avq A 171 176 awyfan
1avq A 172 177 wyfany
1c7k A 2 7... (3 Replies)
Discussion started by: InfoSeeker