Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert rows into columns and create table with awk
Top Forums Shell Programming and Scripting Convert rows into columns and create table with awk Post 303024123 by rprpr on Sunday 30th of September 2018 11:06:35 PM
Old 10-01-2018
Quote:
Originally Posted by Neo
Hi rprpr,

unix.com is not a place where the members do your work for you, regardless of if it is homework, personal or professional work.

We are here to help you do your work, not do your work for you.

Why would you post a "problem" which looks like a typical school question which requires an "urgent reply" saying "it must be awk or any other unix command" without any details of the computer technology available to you and what code you have written or tried so far? Urgent why? Because your teacher told you to have the homework done in two days? Urgent because why? Urgent because you took a computer admin job and have no idea how to create a basic
computer program?

Have you ever written a single line of software?

We are not here to beg you to provide basic technology details and we are not here to do you work for you.

So, if you want help, you need to be very technically specific.

Thanks.
------ Post updated at 03:06 AM ------

I apologize. the "urgent" word came out there by mistake.. i used awk command to create the table and print the values but as you can see that in original output, the fields are arrangee in different orders, hence the columns comes with different values (i.e. columns not matching with its actual fields values). It doesn't need to be awk specially, it can be any command..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert rows into columns

Hi guys Could anyone advise me how to convert my rows into columns from a file My file would be similar to this: A11 A12 A13 A14 A15 ... A1n A21 A22 A23 A31 A41 A51 ... Am1 Am2 Am3 Am4 Am5 ... Amn The number of rows is not the same to the number of columns Thanks in advance (2 Replies)
Discussion started by: loperam
2 Replies

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 (1 Reply)
Discussion started by: Nishithinfy
1 Replies

3. Programming

Creating a table like format with rows and columns

I have few files which have two columns in each. like e2 1 1 2694 2 4 2485 3 2 2098 5 1 2079 6 5 2022 9 4 1734 11 5 1585 13 2 1461 18 1 1092 21 2 1019 24 1 915 25 3 907 27 1 891 28 3 890 34 1 748 39 1 700 (1 Reply)
Discussion started by: kamuju
1 Replies

4. UNIX for Dummies Questions & Answers

Convert rows to columns using AWK

Hi , I am struck while coding AWK script. Need your help to convert rows into columns. I should copy only those rows which are marked to Y in a file and ignore N rows. Please help me find a solution. input file 1|abc|Y 2|cdf|Y 3|efg|N 4|xyz|Y my output should be something like this... (2 Replies)
Discussion started by: rashmisb
2 Replies

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

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 (2 Replies)
Discussion started by: infasriniit
2 Replies

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

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

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

10. Shell Programming and Scripting

Convert rows to columns

hi folks, I have a sample data like what is shown below: 1,ID=1000 1,Org=CedarparkHospital 1,cn=john 1,sn=doe 1,uid=User001 2,uid=User002 2,ID=2000 2,cn=steve 2,sn=jobs 2,Org=Providence I would like to convert it into the below format: 1,1000,CedarparkHospital,john,doe,User001... (11 Replies)
Discussion started by: vskr72
11 Replies

LEARN ABOUT DEBIAN

photon

PHOTON(1)																 PHOTON(1)

NAME

       photon - generates photo albums

SYNOPSIS

       photon [OPTIONS] [PATH]

DESCRIPTION

       Photon generates clean, yet configurable, static HTML photo galleries. All of the work is done from the command line, and the resulting
       output can easily be configured by changing the template files found in /usr/share/photon/templates.

       To create a new template (skin), first create a new directory:

	  mkdir -p ${HOME}/.photon/templates/my_theme/

       Then copy the contents of /usr/share/photon/templates/photonv1/ to this new directory.  Photon only needs three files to build pages:

       index.html
	  used to display the content of a folder

       image.html
	  used to display the page for an image

       movie.html
	  used to display the page for a movie

       If a file is missing, then photon will throw an error and will not run.

HOW TO BUILD A GALLERY

       Quick start
	  $ photon -o myoutputdir /photos

       Use the gimp plugin
	  $ photon --resize-plugin=gimp -v -o myoutputdir /photos

       Change the size for all images and the thumbnail and keep the original photo
	  $ photon --sizelist=0,1600x1200,800x600 --thumbsize=320x240 -o myoutputdir /photos

       Create a gallery from your custom template (skin)
	  $ photon -k my_theme -o myoutputdir /photos

       See photon help
	  $ photon --help

OPTIONS

       -a | --awstats
	  Insert Javascript for Awstats

       --awstats-url=URL
	  Change default value for Awstats script url

       -c NAME | --comment
	  Name of the comment file (default .comments)

       -d NUM | --display-columns=NUM
	  Number of columns in index (default 3)

       -E | --no-exif
	  Don't include EXIF information in HTML file

       -f | --force
	  Overwrite non-image generated files (html, javascript, etc) (default no)

       -ff | --force --force
	  Overwrite image files (default no)

       -h | --help
	  Print this help

       -I | --no-index
	  Do not generate the high level index.html

       -J | --no-javascript
	  Do not use javascript (no shortcuts, ... )

       -k | --skin=THEME
	  Skin selector (default photonv1)

       --print-skins
	  Print out available skins (templates)

       -l NUM | --display-lines=NUM
	  Number of lines in index (default 5)

       -m | --movie
	  Movie mode, include link to movie (*.mov)

       -o NAME | --output-directory=NAME
	  Name of the output directory

       -s LIST | --sizelist=LIST
	  Image sizes (default 0,1024x768,800x600,640x480). Zero, which is the default, uses the original resolution. W x H specifies the width
	  and height of the image in pixels.

       -t SIZE | --thumbsize=SIZE
	  Size of thumbnails (default 160x120)

       -v | --verbose
	  Verbosely print information

       -V | --version
	  Print program version number

       -z | --compress
	  Compress the original image if selected (default copy the image)

       --exif-bordercolor=COLOR
	  Exif window border color (default #008000)

       --exif-bgcolor=COLOR
	  Exif window background color (default #f0fff0)

       --exif-fgcolor=COLOR
	  Exif window text color (default black)

       --body-bgcolor=COLOR
	  Body background color (default #ccccff)

       --img-bgcolor=COLOR
	  Image background color (default white)

       --exclude=PATTERN
	  Exclude files matching PATTERN

       --resize-plugin=PLUG
	  Where PLUG is the program used to create thumbnails internal: fastest method (default) gimp: use Gimp>1.x (better quality)

       --resize-quality-low=NUM
	  Quality for small image. 0 (bad) and 100 (good)

       --resize-quality-high=NUM
	  Quality for big image 0 (bad) and 100 (good)

       --gimp-program=PROG
	  use PROG for gimp

SHORTCUTS WHILE VIEWING AN IMAGE

	  n/SPACE     Go to the next image (with the same resolution)
	  p/BACKSPACE Go to the previous image (with the same resolution)
	  s	      Start/Stop the slideshow
	  +/-	      Increase/Decrease by one second the slideshow's period
	  h	      Show shortcut and help
	  i	      Show Exif information
	  z	      Change to the higher resolution [NOT YET IMPLEMENTED]

SEE ALSO

	  gimp(1)

AUTHOR

	  Written by Luc Saillard, <luc@saillard.org>

	  Main web site: http://www.saillard.org/programs_and_patches/photon/

	  This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian project but may be used by others.

								    12/16/2006								 PHOTON(1)
All times are GMT -4. The time now is 08:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy