Sponsored Content
Full Discussion: Pivot using awk
Top Forums Shell Programming and Scripting Pivot using awk Post 302906606 by Scrutinizer on Saturday 21st of June 2014 08:48:29 AM
Old 06-21-2014
Quote:
Originally Posted by protocomm
and this ???

Code:
 awk -F"[: ]" 'BEGIN{ORS="|";}{print $NF}' file

That works too, but the problem is that the last character is a pipe symbol instead of a newline.
 

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

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

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

6. Shell Programming and Scripting

Pivot data using awk

Hi My Input is like below DELETE|MPI|AUD_UPD_AGENT|MPISYS INSERT|MPI|AUD_UPD_AGENT|MPISYS SELECT|MPI|AUD_UPD_AGENT|MPISYS UPDATE|MPI|AUD_UPD_AGENT|MPISYS DELETE|MPI|BDYMOD|MPISYS INSERT|MPI|BDYMOD|MPISYS SELECT|MPI|BDYMOD|MPISYS UPDATE|MPI|BDYMOD|MPISYS DELETE|MPI|BDYMOD_DESC|MPISYS... (4 Replies)
Discussion started by: dineshaila
4 Replies

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

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

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

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... (3 Replies)
Discussion started by: redaela
3 Replies
orddict(3erl)						     Erlang Module Definition						     orddict(3erl)

NAME
orddict - Key-Value Dictionary as Ordered List DESCRIPTION
Orddict implements a Key - Value dictionary. An orddict is a representation of a dictionary, where a list of pairs is used to store the keys and values. The list is ordered after the keys. This module provides exactly the same interface as the module dict but with a defined representation. One difference is that while dict considers two keys as different if they do not match ( =:= ), this module considers two keys as different if and only if they do not com- pare equal ( == ). DATA TYPES
ordered_dictionary() as returned by new/0 EXPORTS
append(Key, Value, Orddict1) -> Orddict2 Types Key = Value = term() Orddict1 = Orddict2 = ordered_dictionary() This function appends a new Value to the current list of values associated with Key . An exception is generated if the initial value associated with Key is not a list of values. append_list(Key, ValList, Orddict1) -> Orddict2 Types ValList = [Value] Key = Value = term() Orddict1 = Orddict2 = ordered_dictionary() This function appends a list of values ValList to the current list of values associated with Key . An exception is generated if the initial value associated with Key is not a list of values. erase(Key, Orddict1) -> Orddict2 Types Key = term() Orddict1 = Orddict2 = ordered_dictionary() This function erases all items with a given key from a dictionary. fetch(Key, Orddict) -> Value Types Key = Value = term() Orddict = ordered_dictionary() This function returns the value associated with Key in the dictionary Orddict . fetch assumes that the Key is present in the dictio- nary and an exception is generated if Key is not in the dictionary. fetch_keys(Orddict) -> Keys Types Orddict = ordered_dictionary() Keys = [term()] This function returns a list of all keys in the dictionary. filter(Pred, Orddict1) -> Orddict2 Types Pred = fun(Key, Value) -> bool() Key = Value = term() Orddict1 = Orddict2 = ordered_dictionary() Orddict2 is a dictionary of all keys and values in Orddict1 for which Pred(Key, Value) is true . find(Key, Orddict) -> {ok, Value} | error Types Key = Value = term() Orddict = ordered_dictionary() This function searches for a key in a dictionary. Returns {ok, Value} where Value is the value associated with Key , or error if the key is not present in the dictionary. fold(Fun, Acc0, Orddict) -> Acc1 Types Fun = fun(Key, Value, AccIn) -> AccOut Key = Value = term() Acc0 = Acc1 = AccIn = AccOut = term() Orddict = ordered_dictionary() Calls Fun on successive keys and values of Orddict together with an extra argument Acc (short for accumulator). Fun must return a new accumulator which is passed to the next call. Acc0 is returned if the list is empty. The evaluation order is undefined. from_list(List) -> Orddict Types List = [{Key, Value}] Orddict = ordered_dictionary() This function converts the Key - Value list List to a dictionary. is_key(Key, Orddict) -> bool() Types Key = term() Orddict = ordered_dictionary() This function tests if Key is contained in the dictionary Orddict . map(Fun, Orddict1) -> Orddict2 Types Fun = fun(Key, Value1) -> Value2 Key = Value1 = Value2 = term() Orddict1 = Orddict2 = ordered_dictionary() map calls Func on successive keys and values of Orddict to return a new value for each key. The evaluation order is undefined. merge(Fun, Orddict1, Orddict2) -> Orddict3 Types Fun = fun(Key, Value1, Value2) -> Value Key = Value1 = Value2 = Value3 = term() Orddict1 = Orddict2 = Orddict3 = ordered_dictionary() merge merges two dictionaries, Orddict1 and Orddict2 , to create a new dictionary. All the Key - Value pairs from both dictionaries are included in the new dictionary. If a key occurs in both dictionaries then Fun is called with the key and both values to return a new value. merge could be defined as: merge(Fun, D1, D2) -> fold(fun (K, V1, D) -> update(K, fun (V2) -> Fun(K, V1, V2) end, V1, D) end, D2, D1). but is faster. new() -> ordered_dictionary() This function creates a new dictionary. size(Orddict) -> int() Types Orddict = ordered_dictionary() Returns the number of elements in an Orddict . store(Key, Value, Orddict1) -> Orddict2 Types Key = Value = term() Orddict1 = Orddict2 = ordered_dictionary() This function stores a Key - Value pair in a dictionary. If the Key already exists in Orddict1 , the associated value is replaced by Value . to_list(Orddict) -> List Types Orddict = ordered_dictionary() List = [{Key, Value}] This function converts the dictionary to a list representation. update(Key, Fun, Orddict1) -> Orddict2 Types Key = term() Fun = fun(Value1) -> Value2 Value1 = Value2 = term() Orddict1 = Orddict2 = ordered_dictionary() Update a value in a dictionary by calling Fun on the value to get a new value. An exception is generated if Key is not present in the dictionary. update(Key, Fun, Initial, Orddict1) -> Orddict2 Types Key = Initial = term() Fun = fun(Value1) -> Value2 Value1 = Value2 = term() Orddict1 = Orddict2 = ordered_dictionary() Update a value in a dictionary by calling Fun on the value to get a new value. If Key is not present in the dictionary then Initial will be stored as the first value. For example append/3 could be defined as: append(Key, Val, D) -> update(Key, fun (Old) -> Old ++ [Val] end, [Val], D). update_counter(Key, Increment, Orddict1) -> Orddict2 Types Key = term() Increment = number() Orddict1 = Orddict2 = ordered_dictionary() Add Increment to the value associated with Key and store this value. If Key is not present in the dictionary then Increment will be stored as the first value. This could be defined as: update_counter(Key, Incr, D) -> update(Key, fun (Old) -> Old + Incr end, Incr, D). but is faster. NOTES
The functions append and append_list are included so we can store keyed values in a list accumulator . For example: > D0 = orddict:new(), D1 = orddict:store(files, [], D0), D2 = orddict:append(files, f1, D1), D3 = orddict:append(files, f2, D2), D4 = orddict:append(files, f3, D3), orddict:fetch(files, D4). [f1,f2,f3] This saves the trouble of first fetching a keyed value, appending a new value to the list of stored values, and storing the result. The function fetch should be used if the key is known to be in the dictionary, otherwise find . SEE ALSO
dict(3erl) , gb_trees(3erl) Ericsson AB stdlib 1.17.3 orddict(3erl)
All times are GMT -4. The time now is 10:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy