Tagged Questions
0
votes
1answer
21 views
moving columns across rows
I am dealing with a txt file and trying to keep the first column/field in place, but shift the 2nd column down by 1 row. I tried this, but it gave the error unmatched .'s.
awk '{for(i=1; i<NR; ...
2
votes
2answers
296 views
Data pivot with awk
I'm trying to pivot a file using awk. This is an example of my input File:
VarName;TimeString;VarValue;Validity;Time_ms
A;23.11.201215:03:53;1;1;41236627696,7593
...
1
vote
3answers
128 views
Merging content of two files with comparing content of column
I have a problem trying to merge content of two files :
file 1 :
873 1.1.1.1
1033 99.99.99.10
1108 78.2.204.174
1257 78.2.8.181
file 2:
test1 78.2.8.181 p6
test2 99.99.99.10 p9
test7 1.1.1.1 ...
1
vote
1answer
156 views
Combining files with 4 columns each, into 4 files for each column [closed]
So I have a bunch of text files which look like this:
T1
r1 a b c d
r2 d e f g
...
T2
r1 h i j k
r2 l m n o
...
And I want to make FOUR different text files in the following ...
5
votes
7answers
249 views
Swapping an unlimited number of columns
I have a file with columns. See below for an example:
a b c ... z
1 2 3 ... 26
I'd like to swap all columns where the 1st becomes the last, the second becomes the one before last...etc..
z y x ...
3
votes
2answers
100 views
Column mismatch and substituting
input.txt (tab-delimted)
TTTTOTTT00000000008 RTTTT899 5.00E-28
TTTTOTTT00000000046 RTTTWRR 3.00E-31
TTTTOTTT00000000051 2.00E-11
TTTTOTTT00000000051 7.00E-12
TTTTOTTT00000000054 ...
2
votes
1answer
186 views
text processing-perl
I am a biologist. I would like help of computer experts to help in text file editing.
Here is what the input file looks like:
##dsfsd2
##sdf-sdf sasg 5.6.3
gi34_ex Gen CDS 161 317 . ...
