Script to do column to row


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Script to do column to row
Prev   Next
# 1  
Old 01-31-2020
Script to do column to row

Hi ,

Can anyone help me suggesting - how to do the below trick with awk

Input
100
120
130
140
210
310
410
645
729
800

Output
120 130 140
210 310 410
645 729 800

Many many thanks
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Script to do column to row in awk

Hi , Can anyone help me suggesting - how to do the below trick with awk Input 120 130 140 210 310 410 645 729 800 Output 120 130 140 (6 Replies)
Discussion started by: Indra2011
6 Replies

2. Shell Programming and Scripting

awk script row to column

Hi.. I have data : Report testing1 20180419 08:00 Report testing2 20180419 07:35 Report testing 20180419 08:01 Source = data1 Report testing4 20180419 08:05 Source = data1 Report testing5 20180419 08:10 Source = data2 Report testing6 20180419 08:01 Report testing7 20180419 08:19... (4 Replies)
Discussion started by: buncit8
4 Replies

3. Shell Programming and Scripting

Script changing row to column

Hi Gurus, I have an I/P file which looks like 100 1 200 1 300 4 100 2 200 3 300 4 100 9 200 8 300 7 I would liek to get O/P as 100 200 300 1 1 4 2 3 4 (8 Replies)
Discussion started by: Indra2011
8 Replies

4. 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 (4 Replies)
Discussion started by: cdfd123
4 Replies

5. Shell Programming and Scripting

Script: Convert row in to column

Hi, i need to convert SG_ERP1 SG_ERP2 SG_ERP3 in to: SG_ERP1 SG_ERP2 SG_ERP3 It's possibile? (16 Replies)
Discussion started by: elilmal
16 Replies

6. 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 (11 Replies)
Discussion started by: ks_reddy
11 Replies

7. Shell Programming and Scripting

AWK Script - Print a column - within a Row Range

Hi, Please read the whole thread. I have been working on this script below. It works fine, feel free to copy and test with the INPUT File below as well. example: PACKET DATA PROTOCOL CONTEXT DATA APNID PDPADD EQOSID VPAA PDPCH PDPTY PDPID 10 ... (6 Replies)
Discussion started by: panapty
6 Replies

8. Shell Programming and Scripting

Moving data from a specified column/row to another column/row

Hello, I have an input file like the following: 11_3_4 2_1_35 3_15__ _16989 Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies

9. Shell Programming and Scripting

column to row convert - script - help

Hi, I have a file named col.txt 1.000 2.000 3.000 4.000 5.000 6.000 7.000 8.000 I should get this 1.000 5.000 2.000 6.000 3.000 7.000 (10 Replies)
Discussion started by: G0Y
10 Replies

10. 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... (9 Replies)
Discussion started by: aYankeeFan
9 Replies
Login or Register to Ask a Question
MOTO(9.1)																 MOTO(9.1)

NAME
moto - create animation scripts SYNOPSIS
fb/moto [ -fstart end ] [ -sskip ] [ file [ arg ... ] ] DESCRIPTION
Moto is a command generator tailored for an animator's needs. Its input is a concise description of the animation to be produced; its out- put is a command file suitable for input to rc or some other command interpreter. Its arguments are an optional file name containing a moto program (default standard input) and list of numeric parameters that are made available to the program. A moto program consists of a list of groups of commands guarded by a range of frames. Groups may contain parameter ranges enclosed in brackets []. For each frame, moto checks each group and processes those whose guards include the current frame number: 1,6: clr 128 1,4: clr -w [0,30] [0,30] [100,130] [100,130] 3,6: clr -w [100,70] [100,70] [130,100] [130,100] 255 This generates clr 128 clr -w 0 0 100 100 clr 128 clr -w 10 10 110 110 clr 128 clr -w 20 20 120 120 clr -w 100 100 130 130 255 clr 128 clr -w 30 30 130 130 clr -w 90 90 120 120 255 clr 128 clr -w 80 80 110 110 255 clr 128 clr -w 70 70 100 100 255 Two special guards, BEGIN and END, specify actions to be taken before and after processing frames. Moto allows complex computations inside parameter brackets: 1,10: clr [127.5*(1-cos([0,360]))] This generates clr 0 clr 29.82933350233 clr 105.35985734747 clr 191.25 clr 247.3108091502 clr 247.3108091502 clr 191.25 clr 105.35985734747 clr 29.82933350233 clr 0 Expressions may include constants and variables. All values are double-precision floating point numbers. The operators =, /, +, - (both unary and binary), <, >, <=, >=, ==, !=, ?: and !, all with their meanings as in C, except that all results are coerced to double. The result of a%b is a-b*(int)(a/b). The result of a&&b is a?b:a. The result of a||b is a?a:b. The exponentiation operator is ^, also writ- ten **. The expression [a,b] varies from a to b, linearly as the frame number varies between the guards of the group containing the expression. The expression a[b,c] has the value a*b+(1-a)*c. Its value varies from b to c as a varies from 0 to 1. The expression $i has the value of the i'th parameter following the file name on moto's command line. The precedence of operators is, from lowest to highest: = ? : || && < <= == != > >= + - * / % [ ] ^ ** - (unary) ! $ Expressions may be parenthesized to alter precedence. The following math functions are available: fabs floor ceil sqrt hypot sin cos tan asin acos atan exp log log10 sinh cosh tanh All math functions are as described in the C library, except that angles are measured in degrees rather than radians for the trig and inverse trig functions. In addition hypot may have two or three arguments, atan may take two arguments instead of one, and may also be spelled atan2. For parameterization, and to allow even more complex computations, moto has variables, assignment and computation groups. A computation group causes no output; rather its body is a group of expressions to be evaluated for their side effects. It is distinguished from a com- mand group by having a double colon separating the guard and body: BEGIN:: n=5 1,n:: x=512*sin([0,90]) 1,n: pcp -w 0 0 [x] 488 pic.[1,n] %0 This generates pcp -w 0 0 0 488 pic.1 %0 pcp -w 0 0 195.93391737093 488 pic.2 %0 pcp -w 0 0 362.03867196751 488 pic.3 %0 pcp -w 0 0 473.02632064578 488 pic.4 %0 pcp -w 0 0 512 488 pic.5 %0 Upon occasion it is useful to split moto's output into several files, under program control. A group that is separated from its guards by an at-sign @ instead of a colon names a file into which subsequent output is to be written. For example, 1,5@ file.[1,5] 1,5: This is file.[1,5]. creates 5 files, with names file.1, ..., file.5. Each file's contents will announce its name. As is true for all sufficiently large programs, moto has a shell escape. The text of a group separated from its guards by an exclamation point ! causes a copy of rc(1) to be started. The group's text is sent to rc's standard input, and its standard output inserted into moto's output. SOURCE
/sys/src/fb/moto.y MOTO(9.1)