Sponsored Content
Top Forums Shell Programming and Scripting Vertical an horizontal pivoing in unix Post 302290409 by marut_ashu on Monday 23rd of February 2009 07:50:55 AM
Old 02-23-2009
Lightbulb

Thanks Cherry this helps but I have one more complication that ....there may be data like this -- (FOr few key values periods may differ and facts as well)

MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4
M1|P1|PR1|F11|F12|F13|F14
M1|P1|PR3|F31|F32|F33|F34
M2|P2|PR1|F41|F42|F43|F44
M2|P2|PR2|F51|F53|F54|F55
M2|P2|PR3|F61|F64|F65|F66
M3|P3|PR3|F71|F72|

and important thing that fact columns may be variable as well...It is possible to address this using perl
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Draw a Horizontal and Vertical line on UNIX

I want to draw a horizontal and vertical line on Unix. Please suggest some solution. (11 Replies)
Discussion started by: allways4u21
11 Replies

2. UNIX for Dummies Questions & Answers

Horizontal to vertical

Hi, Silly question, if I have an excel file that looks something like this: ................. Subject 1 Subject 2 Subject 3 Subject 4 Fever..............13...........9.............23..........14 Headache.........2............12...........18..........23... (3 Replies)
Discussion started by: Xterra
3 Replies

3. UNIX for Dummies Questions & Answers

vertical to horizontal

dear all, i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2. example text : Data DATE XXXXX MAX 47 53 49 51 48 48 7 46 51 8 25 (6 Replies)
Discussion started by: andrisetia
6 Replies

4. Shell Programming and Scripting

Vertical And Horizontal Pivoting

Hi All, My Input data is: A=1 B=2 My desired Output should be: A|B 1|2 Thanks in advance... (3 Replies)
Discussion started by: kmsekhar
3 Replies

5. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

6. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies

7. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

I need to change data from vertical to horizontal but with condition input USA|80 AUS|40 BRA|33 VEGAS|40 KENTUCKY|50 NEWYORK|21 DARWIN|33 ADELAIDE|21 SAOPAOLO|44 RIO|89 GAPIZA|44 BENFLEX|32 AXIS|44 ACRE|56 HEIGHT|22 (5 Replies)
Discussion started by: radius
5 Replies

8. UNIX for Dummies Questions & Answers

Print vertical to horizontal

Hi Masters, I need help to change my vertical data to horisontal input 2015-04-13|JS|741667 2015-04-13|JSJ|2272 2015-04-13|TMS|107099 2015-04-12|JMD|47945 2015-04-13|TM|760024 2015-04-13|JM|484508 2015-04-14|JMJ|318 2015-04-14|JSD|54436 2015-04-13|JM|15410 Output... (2 Replies)
Discussion started by: radius
2 Replies

9. Shell Programming and Scripting

Transform vertical into horizontal list

Hi, I am creating a script that will pull data from database. The only thing missing now is that i have to transform the lines into horizontal list. EXAMPLE 2015-07-15 09:00:00.0 |TCSERVER01 |5354 2015-07-15 09:01:00.0 |TCSERVER01 |6899 ... (5 Replies)
Discussion started by: reignangel2003
5 Replies

10. Shell Programming and Scripting

Need to move vertical to horizontal using paste

Source file Name:hostname1 Masking views : Yes Storage Group Names : hostname1 device (5): Name:hostname2 Masking views : Yes Storage Group Names : hostname2 device (5): Name:hostname3 Masking views : no Storage Group Names : hostname3 device (5):... (9 Replies)
Discussion started by: ranjancom2000
9 Replies
IBID-FACTPACK(1)					     Ibid - Multi-protocol Bot						  IBID-FACTPACK(1)

NAME
ibid-factpack - Factoid-package management utility for Ibid SYNOPSIS
ibid-factpack [-s] factpack-file ibid-factpack -r [-f] factpack-name ibid-factpack -h DESCRIPTION
This utility is for adding and removing sets of packaged factoids, known as factpacks, from your Ibid's factoid database. The default mode is factpack loading. The factpack-file specified is loaded into the bot's database. Should the pack contain any facts with the same name as an existing fact in the bot's database, loading will be aborted, unless the -s option is supplied. Factpacks can be gzipped if the filename ends with .gz. When invoked with the -r option, the named factpack (original import filename minus the extension) will be removed from the bot. If any of the facts contained in that pack were modified while loaded in the bot, unloading will be aborted, unless the -f option is supplied. OPTIONS
-r, --remove Remove the named factpack, rather than importing. -f, --force Force removal, if facts in the factpack were modified by users. -s, --skip Skip facts that clash with existing factoids, during import. -h, --help Show a help message and exit. FACTPACKS
Factpacks are JSON-encoded text files containing a list of facts. Each fact is a tuple of two lists: fact-names, fact-values. The same substitutions are available as in normal online Factoids. Example: [ [["Hello", "Hi"], ["<reply> Hi There", "<action> waves"]], [["Bye"], ["<reply> kbye $who", "<reply> Cheers"]] ] FILES
ibid.ini Locates the database to act upon by looking for the [databases].ibid value in the bot configuration file in the current directory. SEE ALSO
ibid(1), ibid.ini(5), http://ibid.omnia.za.net/ Ibid 0.1 March 2010 IBID-FACTPACK(1)
All times are GMT -4. The time now is 05:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy