Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Pivot example
Top Forums Shell Programming and Scripting Pivot example Post 303032952 by nezabudka on Wednesday 27th of March 2019 06:25:17 AM
Old 03-27-2019
Hi,
Maybe it will brighten the silence?
For instance bash 4.4 linux
Code:
sed -nr '
s/(.{9})(.*)/\1~\2  /;h
b2
:1
s/(.*)(.{3})~(.{3})(.*)/\1\3~\4/
:2
h;T
s/(.{3})(.{3}).*(.{3})~.*/\1 \2 \3/p
g
t1' <<<"SGPAPCTUMACCHEA"

 

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

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

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

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 (3 Replies)
Discussion started by: boston_nilesh
3 Replies

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

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 (8 Replies)
Discussion started by: saj
8 Replies

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

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/... (5 Replies)
Discussion started by: tostay2003
5 Replies

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

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

LEARN ABOUT CENTOS

create_makefile

CREATE_MAKEFILE 						  [FIXME: manual]						   CREATE_MAKEFILE

NAME

       create_makefile - Creates Makefile.in and Makefile from a Makefile.am

SYNOPSIS

       create_makefile [relativepath/Makefile] [relativepath]

DESCRIPTION

       create_makefile creates the Makefile.in and Makefile in a subdirectory containing a Makefile.am. This script saves time compared to
       re-running configure completely

       Note that you must supply the path to the desired MakefileMakefile.am (though the final /Makefile may be omitted).

       This script may be run from the toplevel directory (the one containing configure) or from one of it's subdirectories.

       If the source directory is different from the build directory (see the environment variables below), it will be assumed that the
       Makefile.am and Makefile.in belong beneath the source directory and that the Makefile belongs beneath the build directory.

       This utility is part of the KDE Software Development Kit.

ENVIRONMENT

       One of the following variables (but not both) should be set if the source directory is different from the build directory. If the build
       directory is simply a subdirectory of the source directory, the simpler variable OBJ_SUBDIR should be used.

       OBJ_SUBJDIR
	   Indicates that the build directory is in the given subdirectory of the source directory. For instance, if the source directory is
	   kdesdk and the build directory is kdesdk/obj-i386-linux, then OBJ_SUBDIR should be set to obj-i386-linux.

       OBJ_REPLACEMENT
	   A sed expression that is used to transform the source directory into the build directory. For instance, if the source directory is
	   ~/src/kdesdk and the build directory is ~/src/kdesdk-obj, then OBJ_REPLACEMENT should be set to s#kdesdk#kdesdk-obj#.

SEE ALSO

       create_makefiles(1)

AUTHORS

       create_makefile was written by David Faure<faure@kde.org> and others. This manual page was prepared by Ben Burton<bab@debian.org> for the
       Debian GNU/Linux system (but may be used by others).

[FIXME: source] 						   March 8, 2003						   CREATE_MAKEFILE
All times are GMT -4. The time now is 10:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy