02-23-2009
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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
ibid-factpack
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)