|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Pivoting Dynamic rows into columns
Post 302303520 by Ygor on Thursday 2nd of April 2009 08:49:44 PM
04-02-2009
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file which has values seperated by ~ as shown below and I have to achieve a column to row from this.
Incoming row is like this
How do i get the occueance of ~ and then split it into rows as and below is what I have to achieve.
Thanks (16 Replies)
Discussion started by: mgirinath
16 Replies
2. Shell Programming and Scripting
Hello,
i have a file "Movie.ini" looking e.g. like follows
* MOVIE A
bla bla
MOVIE B
blubb blubb
MOVIE C
I'd like to read the file "Movie.ini" with cat and grep and check whether it includes the string MOVIE only with a '*' at the beginnig.
By doing
"cat Movie.ini| grep MOVIE... (14 Replies)
Discussion started by: ABE2202
14 Replies
3. Shell Programming and Scripting
I have a file thats space delimited that looks something like this:
Joe Smith jsmith 43234 bill1;bill2;read;read2;schedule
Andy Summers asummers 11232 bill1;read
Beth McConnel bmconnel 43443 read;read2;schedule;bill
Susan Fowler sfowler 09332 bill1;read;schedule
I need to... (8 Replies)
Discussion started by: regexnub
8 Replies
4. Shell Programming and Scripting
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies
5. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
6. Shell Programming and Scripting
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies
7. Shell Programming and Scripting
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies
8. Shell Programming and Scripting
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies
9. UNIX for Beginners Questions & Answers
I/P:
I/P:
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/02/01 a 10
2017/02/01 b 20
2017/02/01 c 30
O/P:
a b c
2017/01/01 10 20 40
2017/02/01 10 20 30 (18 Replies)
Discussion started by: Booo
18 Replies
10. UNIX for Beginners Questions & Answers
HI UNIX Gurus,
Not sure if this was already asked and an UNIX Guru has replied but I could not find what i wanted. I have linux environment and need help on this. I have several files like this.
a,1
b,1
utc,10/12/2019
local,10/12/2018
name,xxxy
deg,feh
10,12
20,8
30,50
32,64
46,65... (5 Replies)
Discussion started by: Roopensingh
5 Replies
LEARN ABOUT DEBIAN
metasys
METASYS(8) NUT Manual METASYS(8) NAME
metasys - Driver for Meta System UPS equipment NOTE
This man page only documents the hardware-specific features of the metasys driver. For information about the core driver, see nutupsdrv(8). SUPPORTED HARDWARE
The metasys driver was written with the "Meta System UPS Protocol Rev.1.12" kindly supplied from Meta System. The driver should support all the common features of the ups models: o HF Line (/2) 1-8 boards o HF Millennium (810, 820) o HF TOP Line (910, 920, 930, 940, 950, 970, 980) o ECO Network (750, 1000, 1050, 1500, 1800, 2000, 2100, 2500, 3000) o ECO (305, 308, 311, 511, 516, 519, 522, SX, SXI) o ally HF (800, 1000, 1250, 1600, 2000, 2500) o Megaline (1250, 2500, 3750, 5000, 6250, 7500, 8750, 10000) CABLING
The needed cable is a standard pin-to-pin serial cable with at least pins 2, 3, and 5 (on DB9 connector) connected. EXTRA ARGUMENTS
This driver supports no extra arguments from ups.conf(5). BUGS
This driver has been tested on Meta System HF Millennium 820 and ally HF 1000 only. Any information about the use of the driver with the other listed UPS are really welcome. AUTHOR
Fabio Di Niro <blaxwan@users.sourceforge.net> SEE ALSO
The core driver: nutupsdrv(8) Internet resources: The NUT (Network UPS Tools) home page: http://www.networkupstools.org/ Network UPS Tools 05/21/2012 METASYS(8)