Transposing column to row, joining with another file, then sorting columns Post: 302358428

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like...

2. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N

3. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid

4. Shell Programming and Scripting

Help newbie: transposing column into row (pivot)

5. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done

6. UNIX for Dummies Questions & Answers

File joining and sorting

Hi, I'm having some trouble joining these two files for some reason. Here is what they look like: head * I'm using: join -a 1 -1 2 -2 1 f1 f2 -t, > joinfile.out but unfortunately nothing is happening. I did notice that I was having trouble sorting f1 and I'm not sure why using:...

7. Shell Programming and Scripting

Convert row to columns start from nth column

Dear All, We have input like this: 161 57 1378 176 1392 262 1444 441 1548 538 1611 670 1684 241 57 1378 208 1393 269 1447 444 1549 538 1610 677 1700 321 ...

8. Shell Programming and Scripting

Joining files using awk not extracting all columns from File 2

Hello All I'm joining two files using Awk by Left outer join on the file 1 File 1 1 AA 2 BB 3 CC 4 DD File 2 1 IND 100 200 300 2 AUS 400 500 600 5 USA 700 800 900

9. UNIX for Beginners Questions & Answers

Copy columns from one file into another and get sum of column values and row count

I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv abc.csv- UTF-8,,,,,,,,,,,,,,,,,,,,,,,,, ...

10. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ...

LEARN ABOUT MINIX

cp

CP(1)							      General Commands Manual							     CP(1)

NAME

       cp, cpdir - file copy

SYNOPSIS

       cp [-pifsmrRvx] file1 file2
       cp [-pifsrRvx] file ... directory
       cpdir [-ifvx] file1 file2

OPTIONS

       -p     Preserve full mode, uid, gid and times

       -i     Ask before removing existing file

       -f     Forced remove existing file

       -s     Make similar, copy some attributes

       -m     Merge trees, disable the into-a-directory trick

       -r     Copy directory trees with link structure, etc. intact

       -R     Copy directory trees and treat special files as ordinary

       -v     Display what cp is doing

       -x     Do not cross device boundaries

EXAMPLES

       cp oldfile newfile  # Copy oldfile to newfile

       cp -R dir1 dir2	   # Copy a directory tree

DESCRIPTION

       Cp  copies one file to another, or copies one or more files to a directory.  Special files are normally opened and read, unless -r is used.
       -r also copies the link structure, something -R doesn't care about.  The -s option differs from -p that it only copies  the  times  if  the
       target file already exists.  A normal copy only copies the mode of the file, with the file creation mask applied.  Set-uid bits are cleared
       if the owner cannot be set.  (The -s flag does not patronize you by clearing bits.  Alas -s and -r are nonstandard.)

       Cpdir is a convenient synonym for cp -psmr to make a precise copy of a directory tree.

SEE ALSO

       cat(1), mkdir(1), rmdir(1), ln(1), rm(1).

																	     CP(1)