Convert rows to columns using AWK Post: 302469155

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert columns to rows

Hi, I need a shell script for below requirement Input file P1 - 173310 P2 - 173476 P3 - 173230 P4 - 172737 P1 - 173546 P2 - 173765 P3 - 173876 P4 - 172989 Out put file P1 173310 173546 P2 173476 173765 P3 173230 173876 P4 172737 172989 Suresh

2. Shell Programming and Scripting

convert columns into rows

hi, Apologies if this has been covered. I have requirement where i have to convert a single column into multiple column. My data will be like this - 2 3 4 5 6 Output required - 2 3 4 5 6

3. Shell Programming and Scripting

convert rows to columns

hi, i have the file as below: abc def ghi jkl i want the output as abc,def,ghi,jki please reply, Thanks

4. Shell Programming and Scripting

Convert few columns to rows

Hi! Does anybody help me in converting following data: INPUT looks like this: 20. 100. 30 200. 40. 400. 50. 100. 60. 200. 70. 400. 80. 200. 150. 210. 30. 100. OUTPUT should look like this: 20. 100. 30 200. 40. 400. 50. 100. 60. 200. 70....

5. Shell Programming and Scripting

Convert rows into columns using awk or perl

hi friends, i am able to parse cvs diff file using bit of cut and grep commands to produce following output in text file '''cvs-diff.txt''' Package-Name = dev-freetype. Old-Version = 2.4.8 New-Version = 2.4.10 Patches-removed = freetype-2.4.8-cross-compile.patch...

6. Shell Programming and Scripting

How to Convert rows in to columns?

Hi Gurus, How to convert rows in to columns using linux shell scripting Input is like (sample.txt) ABC DEF GHI JKL MNO PQR STU VWX YZA BCD output should be (sampleoutput.csv) ABC,DEF,GHI,JKL,MNO PQR,STU,VWX,YZA,BCD

7. UNIX for Dummies Questions & Answers

Awk: convert rows to columns every n lines

Hi guys! I use AWK commands under GAMS to predispose the data files to be read by GAMS. I have a file which contains groups of data I need. Unfortunately I have the data spread in 3 rows for each subject. Here's an example (the file is really long) 1 0 2.0956 100.00 250.00 100.00 2.0956...

8. Shell Programming and Scripting

Convert Rows to Columns

Hi Everyone, Could someone shed some lights on how to convert the records in rows form into column basis. 172.29.59.12 IBM,8255-E8B 102691P 8 65536 MB 6100-04-11-1140 172.29.59.15 IBM,8255-E8B 102698P 4 45056 MB 6100-04-11-1140 IP SYS MODEL ...

9. Shell Programming and Scripting

Convert rows to columns

I am looking to print the data in columns and after every 3 words it should be a new row. cat example.out | awk 'END { for (i = 0; ++i < m;) print _;print _ }{ _ = _ x ? _ OFS $1 : $1}' m=1| grep -i INNER I am looking to print in a new line after every 3 words. ...

10. Shell Programming and Scripting

Convert rows into columns and create table with awk

Hello I've four fields . They are First Name, Last Name, Age, Country. So when I run a Unix command, I get below output with these fields comes every time in different order as you can see. Some times first name is the first row and other time last name is first row in the output and etc etc.....

LEARN ABOUT SUSE

pfspad

pfspad(1)						      General Commands Manual							 pfspad(1)

NAME

       pfspad - Add borders to a frame in PFS stream

SYNOPSIS

       pfspad  [--left	<columns>]  [--right <columns>] [--top <rows>] [--bottom <rows>] [--width <new_width>] [--height <new_height>] [--R <val>]
       [--G <val>] [--B <val>] [--Y <val>] [--help]

DESCRIPTION

       Add borders to each frame in PFS stream. User specifies size of left, right, top and bottom border or size of an  output  image.  Color	of
       borders can be specified as well.

OPTIONS

       --left <columns>, -l <columns>
	      Width in pixels of the left border.

       --right <columns>, -r <columns>
	      Width in pixels of the right border.

       --top <rows>, -t <rows>
	      Height in pixels of the top border.

       --bottom <rows>, -b <rows>
	      Height in pixels of the bottom border.

       --width <new_width>, -W <new_width>
	      Width of an output image. Note that --width can be mixed with either --left or --right option.

       --height <new_height>, -H <new_height>
	      Height of an output image. Note that --height can be mixed with either --top or --bottom option.

       --R <val>, -R <val>, --G <val>, -G <val>, --B <val>, -B <val>
	      Color of borders in RGB mode. Default color is black, and if some of the components is not specified, its value is set to 0.0.

       --Y <val>, -Y <val>
	      Color of borders in luminance mode.

       --help, -h
	      Print a list of commandline options.

EXAMPLES

       pfsin image.hdr | pfspad --left 50 --bottom 20 | pfsout out.hdr
	      Add 50 columns to the left and 20 rows to the bottom side of image.hdr.  Color of borders is default black.

       pfsin image.hdr | pfspad --top 20 --height 500 --width 400 --R 1.0 | pfsout out.hdr
	      Add 20 rows to the top side of image.hdr and create output image out.hdr 500 pixels in height and 400 pixels in width. Color of bor-
	      ders is set to red.

SEE ALSO

       pfsin(1) pfsout(1)

BUGS

       Please report bugs and comments to Dorota Zdrojewska <dzdrojewska@wi.ps.pl>.

																	 pfspad(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert columns to rows

Discussion started by: suresh3566

2. Shell Programming and Scripting

convert columns into rows

Discussion started by: Nishithinfy

3. Shell Programming and Scripting

convert rows to columns

Discussion started by: namitai

4. Shell Programming and Scripting

Convert few columns to rows

Discussion started by: lovelinux