Hello,
I have a tab delim file that looks like this
I need the output file to look like this where ID column is merged with the last two. The columns do not have a consistent number of values in it, sometimes its just a single value, sometimes many and sometimes it's a blank.
I tried this
It works for single values (ie last 3-4 rows) but I am not able to merge multiple values together (first few rows).
Hi, I have input file.
File1:
Seqno Name
124 name1
121 name2
123 name3
122 name4
We will send the file1 to some other team. They will replace name column with place in file1 and send back to us as file2.
file2:
Seqno Place
124 place1
121 place2
123 place3file2: (5 Replies)
Hi,
I have two columns that look like this (tab seperated):
name top
carl ball
bob lost
joe smith
I want the two columns to merge and look like this:
nametop
carlball
boblost
joesmith
Also, I want to trim the edges of a column. So lets say the above column... (3 Replies)
I having file below o/p
ibapp311dg,,20480,s,,,,,,,,,
test,,20480,s,,,,,,,,,
test,,20480,s,,,,,,,,,
ibapp311dg,,20480,s,,,,,,,,,
I want to to chk unique word line in the first field seperated by , as well as addup corressponding the number in field for each unique word like
ibapp311dg... (8 Replies)
Hello,
I have a number of tab delimited data files consists of two columns. Like that:
File1
800.000000 0.002744
799.000000 0.002517
798.000000 0.002836
797.000000 0.002553
FIle2
800.000000 0.000261
799.000000 0.000001
798.000000 0.000551
797.000000 0.000275
File3... (19 Replies)
Hi everyone,
I got a problem with merging files and hoped one of you would have an idea how to approach this issue. I tried it with awk, but didn't get far. This is what I have:
I got 40 files looking like the ones below. All have three columns but the number of rows differs (20000 to 50000).... (6 Replies)
Hi,
I have two text files that I would like to merge/join. I would like to join them if the first columns of both text files match and the second column of the first text file matches the third column of the second text file.
Example input:
First file:
1334 10 0 0 1 5.2
1334 12 0 0 1 4.5... (4 Replies)
Hello
I have a file as below
chr1 start ref alt code1 code2
chr1 18884 C CAAAA 2 0
chr1 135419 TATACA T 2 0
chr1 332045 T TTG 0 2
chr1 453838 T TAC 2 0
chr1 567652 T TG 1 0
chr1 602541 ... (2 Replies)
I have two files, file1 and file2 who have identical number of rows and columns. However, the script is supposed to be used for for different files and I cannot know the format in advance. Also, the number of columns changes within the file, some rows have more and some less columns (they are... (13 Replies)