Modify an XLS file with Awk

hello all. I would like to kindly ask you, if you could help me out with one problem. I have two files -> for ex.

Hi All,

I have a text file with below content.

Code: TradeDate Name    SecurityMnc  ReasonDesc        ======================================= 20120501  Robin    ABC      FO System Defect  20120502  Robin    ABC      FO System Defect I would want this in an excel file in 4 columns, am

Hi,

I have a file with 6 columns. I want to check if column 1 and 2 fall between column 5 and 6 I want to call them as "TRUE_genes" if not then call them as "FALSE_genes".

I would like help adding a new column to a large txt file (~10MB) that contains the filename.

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are tab separated.

Hi, I am trying to multiply column#1 with column#2 using a shell script. How can I make a for-loop script using 1st column as "i" and the second column as "j" from the following file?

Hi all,

I'm looking for a way to merge multiple columns (from one file) into a single column in an output file.

The file I have looks somewhat like this:

Code: @HWI-ST212        1:N:0        AGTCCTACCGGGAGT        +        @@@DDDDDHHHHHII @HWI-ST212        1:N:0      &n

Input file

Code: 2        1159,310,          4        142,199,218,91,    3        91,273,349, Desired output result

Code: 2        1469 4        650 3        713 I have long list of input file as shown above. It has a ",&

Dear all, Lets say, I've a file a.txt containing two columns, like

Code: a1  b1 ..  .. ..  .. and another file b.txt containg two columns, like

Code: a1  c1 ..  .. ..  .. I need to put c1 column from b.txt file to the a.txt file.