Pivot example Post: 303032888

Sponsored Content

Top Forums Shell Programming and Scripting Pivot example Post 303032888 by RudiC on Tuesday 26th of March 2019 04:17:09 AM

03-26-2019

Registered User

Welcome to the forum.

Please become accustomed to provide decent context info of your problem.

It is always helpful to carefully and detailedly phrase a request, and to support it with system info like OS and shell, related environment (variables, directory structures, options), preferred tools, adequate (representative) sample input and desired output data and the logics connecting the two including your own attempts at a solution, and, if existent, system (error) messages verbatim, to avoid ambiguities and keep people from guessing.

A guess from staring at your samples: you want the input to be grouped by three chars, and then reassemble those groups into a new pattern, repeating the first group. Is that input in a file, a variable, read from stdin, ...?

Final remark:
Do not post classroom or homework problems in the main forums. Homework and coursework questions can only be posted in this forum under special homework rules.

Please review the rules, which you agreed to when you registered, if you have not already done so.

Last edited by RudiC; 03-26-2019 at 05:34 AM..

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pivot

I have a sql table with : Acitvity Date Value ABC 7/11 10 DEF 7/11 98 ABC 7/12 23 DEF 7/12 100 SER 7/12 67 GRH 7/13 123 HJY 7/14 12 I...

2. Shell Programming and Scripting

Pivot table

Hello everyone, I would like to use awk to parse a file with three columns in, like: monday 0 1 monday 1 1 monday 2 1 monday 3 1 monday 4 1 monday 5 1 tuesday 0 5 tuesday 1 1 tuesday 2 1 tuesday 3 1 tuesday 4 1 wednesday 0 1 monday 5 25 they represent the day the hour and the...

3. Shell Programming and Scripting

Pivot file contents

Hi All, I am trying to pivot the contents in a file. Ex: I have a file sample.txt with data "A B C D", i need the contents to pivot & resulting file should look like "A B C ...

4. Shell Programming and Scripting

Create Pivot table

I would like to use awk to parse a file with three columns in, like: Chennai,01,1 Chennai,07,1 Chennai,08,3 Chennai,09,6 Chennai,10,12 Chennai,11,19 Chennai,12,10 Chennai,13,12 Kerala,09,2 AP,10,1 AP,11,1 Delhi,13,1 Kerala,13,3 Chennai,00,3 Chennai,01,1 Chennai,02,1 Chennai,07,5

5. Shell Programming and Scripting

Pivot script

Hi Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon Below is my input file 1|c2|aa 1|c3|dd 1|c4|cc 1|c5|aa 1|c6|ss 1|c7|dd 1|c8|bb 1|c9|jjj 1|c10|kkk 1|c11|fffg 1|c12|nnn;indi;pak;linf;wer 1|c13|lllnk;li;sdfsd;oiuo 1|c14|ppp...

6. Shell Programming and Scripting

Pivot file content

Hi All , I have a file as below . A "1" B "2" C "3" D "4" E "5" F "6" A "11" B "21" C "31" D "41" E "51" F "61" And the output should be like A B C D E F 1 2 3 4 5 6 11 21 31 41 51

7. UNIX for Dummies Questions & Answers

Pivot multiple

Dear friend, I want to sum popul based on ville and reg. input date country ville reg popul 20131101 INDIA Gujarat College 322047286 20131101 USA Oregon 2 Kindergaten 477305599 20131101 INDIA Delhi 1 Ecole 255029428 20131101 MEXICO ...

8. Shell Programming and Scripting

Pivot using awk

Hi, I am writing a code to basically pivot the data. awk -v var1="" -v var2="" -v var3="" -v var4="" -v var5="" -v Disp=0\ 'BEGIN {FS=":"; OFS="|";}\ /^Pattern1/ {var1=$2;Disp=0;} \ /^Pattern2/ {var2=$2;} \ /^Pattern3/ {var3=$2;} \ /^Pattern4/ {var4=$2;} \ /^Pattern5/...

9. UNIX for Beginners Questions & Answers

Data Pivot

Good Day, I have file input 6285296582710|20170509|INDOTEL 6285296835209|20170509|INDOTEL 6285296940311|20170509|INDOTEL 6285297027737|20170509|MULTIFLAG 6285297027737|20170509|DELTA 6285297304373|20170510|INDOTEL 6285297384129|20170510|INDOTEL 6285296940311|20170510|MULTIFLAG...

10. Programming

DB Query for Pivot

hi team With below results in Db2 v10.5 . Please refer column A and B are same,while Staus column defers with distinct values . A B STATUS Insert Update Old Insert Update New Insert Update Final Can someone guide how to...

LEARN ABOUT DEBIAN

httpfs2

HTTPFS2(1)																HTTPFS2(1)

NAME

       httpfs2 - mount a file from a http server into the filesystem

SYNOPSIS

       httpfs2 [OPTIONS] URL FUSE-OPTIONS httpfs2_ssl [OPTIONS] URL FUSE-OPTIONS

DESCRIPTION

       httpfs2 is a FUSE based filesystem for mounting http or https URLS as files in the filesystem. There is no notion of listable directories
       in http so only a single URL can be mounted. The server must be able to send byte ranges.

OPTIONS

       -c console
	   Attempt to use the file ior device console for output after fork. The default is /dev/console.

       -f
	   Do not fork, stay in foreground.

       -t timeout
	   Use different timeout for connections. Default '30's.

       URL
	   The url should specify the protocol as http or https, and it may specify basic authentication username and password. Currently special
	   characters like whitespace are not handled so the URL cannot contain them. See a sample URL below:

	       http://user:password@server.com/dir/file

       FUSE-OPTIONS
	   These options are passed to the FUSE library. At the very least the mount point should be specified.

EXIT STATUS

       0
	   Successfully connected to the server

       other
	   Failure (url parsing error, server error, FUSE setup error). Some FUSE errors may happen only after the process forks so they will not
	   be returned in exit value.

BUGS

       The process can be stopped by typing ^Z on the terminal which may not be desirable under some circumstances.

AUTHORS

	   Miklos Szeredi <miklos@szeredi.hu>
	   hmb	marionraven at users.sourceforge.net
	   Michal Suchanek <hramrach@centrum.cz>

COPYING

       Free use of this software is granted under the terms of the GNU General Public License (GPL).

								    03/13/2010								HTTPFS2(1)