Search Results

Hello,
I need to match one file with another.

The best would be to give an example.

File 1

A 1
B 2
C 3
D 4
E 5
F 6

File 2

A 5 6 2
B 3 2 1
F 4 2 9

Hi, I tried all teh solutions and no matter what I put in as the input, the answer is always the same. I get something like

1 1
1 1
1 1
.....

Hi,

I have a file that looks like this:

Jake 2 3 4 6 4 3 -2 -1
Jerry 1 2 3 2 1 7 -6 -1
Timmy -1 -4 -5 -8 9 3 1

I want to find the most positive and negative...

hi

i tried

man mv *.lop.txt file

with file being the folder but nothing happens.

Hi I want to transfer all files in a folder to another folder. So the files have a ending of .lop.txt

thanks

Hello,

I have multiple files in a folder that i want to combine into one.

I want the file name to be listed on the first column

so I have several files:

file1

23 11 11 11

file2...

jar1 0.2
jar1 0.4
jar1 0.2
jar1 0.1
jar1 0.3
jar1 0.2
jar2 2
jar2 2
jar2 1
jar2 7
jar2 0.4
jar2 0.2
jar2 0.5
jar2 0.7

before it was like this

Hi
I have a file that is organized like this. Basically the name is indicated by >name, then on a newline there is a sequence of letters. The letters are ASKL however sometimes there are non...

what if the values were on a string instead of in columns

eg.

# 123P5678
# 334434U3
# 23H1233

lets say i want to remove anything less than 8 on column 2

so the end result would be:

#...

Hi,

I want to delete rows that dont have a certain # of columns. In my case, rows that are less than 8 should be removed (those greater than 8 are ok).

For instance:

1 2 3 4 5 6 7 8...

ive been using the

grep -f file2 file1 >final_file

but it is VERY slow. How can I make things go faster? the first file is not sorted... could this be a reason?

hey

$ awk '{printf $1}
{for (i=2;i<=10;i++) if ($i>=0) {printf " "11-i"|"$i} }
{for (j=11;j<=NF;j++) tol++} {print " " tol}
{tol=0} ' urfile

works but I have decimal places for some of the...

Hi,

I have a file that looks like this (tab seperated):

Barry -3 -4 -5 -10 -4 6 -8 20 -6 NaN NaN NaN
Brend -2 4 -3 -7 -3 8 -9 -10 -6 NaN NaN NaN NaN NaN
Harry -10...

just curious, how would i make it skip the first two columns (instead of just the first)..

thanks

Hello,

I am trying to average multiple columns simultaneously while skipping the first column.

I am using this awk line to average one column

awk '{sum+=$3} END { print "Average =...

hi

I am still getting a blank document. hmm

Hmm I tried but a blank document comes out. Maybe I forgot to mention that the file is tab delimited. Also does it need to be sorted in a particular order?

Hi all,

I have a file that contains about 1000 rows and 800 columns. Nearly every row has 800 columns but some DONT. I want to extend the rows that dont have values with NA's. Here is an...

Hi everyone,

I have a file that contains multiple columns. Basically the identifiers are on column 1. Here is an example:

target1 6.7 8.4
target2 5.3 2.3
target3 4.3 2.3My goal is to...