Pivot data using awk Post: 302973674

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

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...

3. Shell Programming and Scripting

Help with parsing data with awk , eliminating unwanted data

Experts , Below is the data: --- Physical volumes --- PV Name /dev/dsk/c1t2d0 VG Name /dev/vg00 PV Status available Allocatable yes VGDA 2 Cur LV 8 PE Size (Mbytes) 8 Total PE 4350 Free PE 2036 Allocated PE 2314 Stale PE 0 IO Timeout (Seconds) default --- Physical volumes ---...

4. Shell Programming and Scripting

awk --> math-operation in data-record and joining with second file data

Hi! I have a pretty complex job - at least for me! i have two csv-files with meassurement-data: fileA ......

5. 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/...

6. Shell Programming and Scripting

Pivot Column using awk

Hello everyone I have a 20M file which is having the below sample layout 1111,ABC,100 1111,DEF,200 1111,XYZ,300 4444,LMN,100 4444,AKH,500 4444,WCD,400 2222,ABC,100 7777,DEF,300 7777,WCD,300 I need to covert this to below format Output Party_ID|ABC|AKH|DEF|LMN|WCD|XYZ...

7. Shell Programming and Scripting

UNIX command to pivot data

Input data Output Required Tried this but not giving right results: nawk -F"|" '{for (i=1;i<=NF;i++) print $NF}' filename Please help me fix this. And also explain the logic how you did it so, I can do it next time. Thanks for your help.

8. 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...

9. Shell Programming and Scripting

Awk- Pivot Table Averages

Hi everyone, Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages. For example, suppose you have the following table with various individuals and their scores in round1 and round2: SAMPLE SCORE1 SCORE2 British ...

10. Shell Programming and Scripting

Pivot example

Hi all, I am new to shell scripting so pardon me for the questions I will be asking. I was given a task where I have to pivot my data Example Source SGPAPCTUMACCHEA Expected output SGP APC TUM SGP APC ACC SGP APC HEA Can anybody assist me on this?Please use CODE tags as required...

LEARN ABOUT OSF1

diction

diction(1)						      General Commands Manual							diction(1)

NAME

       diction, explain, suggest - Prints wordy sentences and looks them up in an interactive thesaurus.

SYNOPSIS

       diction [-fpattern_file] [-k] [-ma] [-me] [-ml] [-ms] [-n] [file...]

       explain

       suggest

       The  diction command finds all sentences in an English language document that contain phrases from a database of bad or wordy diction.  The
       explain command is an interactive thesaurus for the English language phrases found by the diction command and only for those phrases.

       The diction command reads from standard in if no file operand is provided.

       The suggest command is a synonym for explain.

OPTIONS

       Names a user-created pattern file to be used in addition to the default file.  Passes the -k option to the deroff command.  The	-k  option
       keeps  blocks  of  text	specified nroff by requests or macros; for example, the request.  Passes the -ma option to deroff.  The -ma option
       interprets nroff man macros only.  Overrides the default nroff -ms macro package.  Causes deroff to skip lists; should be used if  a  docu-
       ment  contains  many  lists of nonsentences.  Overrides the default nroff -ms macro package.  Suppresses use of the default file (used with
       -f).  Only the user-created pattern file is used.

DESCRIPTION

       Each phrase found by the diction command is enclosed in [ ] (brackets).	Because diction runs deroff before looking at  the  text,  include
       formatting header files as part of the input.

       Before using the explain command, use the diction command to obtain a list of poorly worded phrases.  When you use the explain command, the
       system prompts you for a phrase and responds with a grammatically acceptable alternative.  You can continue typing phrases, or you can exit
       by pressing the End-of-File key sequence.

       The explain command can also take input redirected from a file. No other command line arguments are valid.

NOTES

       Use of nonstandard formatting macros may cause incorrect sentence breaks.  In particular, diction does not understand -me.

FILES

       Default pattern file.  Thesaurus used by the explain command.

SEE ALSO

       Commands:  deroff(1), nroff(1)

																	diction(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pivot

Discussion started by: mukhanj

2. Shell Programming and Scripting

Pivot script

Discussion started by: mabarif16

3. Shell Programming and Scripting

Help with parsing data with awk , eliminating unwanted data

Discussion started by: rveri

4. Shell Programming and Scripting

awk --> math-operation in data-record and joining with second file data

Discussion started by: IMPe