03-26-2019
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..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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 FREEBSD
mkcsmapper
MKCSMAPPER(1) BSD General Commands Manual MKCSMAPPER(1)
NAME
mkcsmapper -- generates hashed conversion data for iconv(3)
SYNOPSIS
mkcsmapper [-mpd] -o outfile infile
DESCRIPTION
The mkcsmapper utility generates binary conversion data from plain text conversion tables for the iconv(3) library. The conversion data has
two components: The conversion mapping between specific character encodings. A pivot file, which the possible source and destination encod-
ing pairs or the set of mappings to use for a compound encoding.
The following options are available:
-d Turns on debug mode.
-m Generate mapping data from infile.
-o outfile
Put generated binary data to outfile.
-p Generate pivot data from outfile.
EXIT STATUS
The mkcsmapper utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
iconv(1), mkesdb(1), iconv(3)
HISTORY
mkcsmapper first appeared in NetBSD 2.0, and made its appearance in FreeBSD 9.0.
AUTHORS
This manual page was written by Gabor Kovesdan <gabor@FreeBSD.org>.
BSD
Sep 6, 2009 BSD