10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello Team,
Could you please help me with the below question?
I have a file with the following properties
1) File Delimiter is ;
2) Text columns are within double quotes
3) Numeric columns will not have double quotes
4) File has total 6 columns
Please see a sample record from file
... (3 Replies)
Discussion started by: sam99
3 Replies
2. Shell Programming and Scripting
Hi,
I wanted to create an automated script that will output a create table statement in unix. Below is the input and the desired output:
INPUT:
desc ZZ_APL_TIDDATELIST
(
TID NUMBER
AEX_DATE TIMESTAMP(6)
)
desc ZZ_APL_TIDLIST
(
TID NUMBER
)
desc... (5 Replies)
Discussion started by: reignangel2003
5 Replies
3. Shell Programming and Scripting
HI
Am totally confused with sed and translate command command.. My problem is
I have a file like
# vi test.csv
ABC_IMUY
ERD0_FN
VEG_NON_DES_IYT
BUY4_FLOW
POI_SHD_URDF_IYUT_REDS_CYC
UYT_PMC4_WIND
EX_FRE_FRD_L2_REF_FLICT
JHY_SGT_DSE_L2
IYO_HYTR_FGT_L3_BGT_ICT... (5 Replies)
Discussion started by: Priya Amaresh
5 Replies
4. UNIX for Dummies Questions & Answers
I have this:
((9:0.010,(11:0.089,13:0.004))
and I would like this:
((A9,(A11,A13))
How do I delete the semi colon and the number (i.e. 0.010) after the semi colon? Also, how can I add the letter before the number that is NOT removed?
Thank you in advance!
---------- Post updated... (4 Replies)
Discussion started by: MDeBiasse
4 Replies
5. Shell Programming and Scripting
Hi,
I have a script which I need to change. I want to add a semicolon at the end of each line where the line starts with "grant"
for e.g.
create table(....
);
grant select on TABL1 to USER1
grant select on TABL1 to USER2should become
create table(....
);
grant select on TABL1 to... (3 Replies)
Discussion started by: pparthiv
3 Replies
6. Shell Programming and Scripting
I want to search/grep for a set of characters in a file(all occurences) and move them to another file.
Any command line?
regards,
Sri (2 Replies)
Discussion started by: Sriranga
2 Replies
7. Shell Programming and Scripting
(5 Replies)
Discussion started by: number10
5 Replies
8. Shell Programming and Scripting
I have a file that is formatted in this way.
a1;b2;c33;d4;e5;e;f;f;f;s
d;ds;d;a;v;b;g;gr;r;rt;fdf
s1;s2;s2;s3;s4;
b1;f2;g3;h4;a3c4e;xcsd;fds;
sd2;fs4;fs2;sdf3;
I want to replace the value just before the 4th semicolon to empty string, regardless the value, such that it looks... (3 Replies)
Discussion started by: alienated
3 Replies
9. Shell Programming and Scripting
I have the following text format in a file which lists the question first and then 5 choices
after that the explanantion and finally the answer.
1.The amount of time it takes for most of a worker’s occupational knowledge and skills to become
obsolete has been declining because of the... (2 Replies)
Discussion started by: nanchil_guy
2 Replies
10. Shell Programming and Scripting
hi,
Consider there is a file containing 200 lines. please let me know which command is to be used to put a semicolon at the end of each line. if no single command is there then how it can be achieved. (1 Reply)
Discussion started by: surjyap
1 Replies
RRDXPORT(1) rrdtool RRDXPORT(1)
NAME
rrdxport - Export data in XML format based on data from one or several RRD
SYNOPSIS
rrdtool xport [-s|--start seconds] [-e|--end seconds] [-m|--maxrows rows] [--step value] [--json] [--daemon address] [DEF:vname=rrd:ds-
name:CF] [CDEF:vname=rpn-expression] [XPORT:vname[:legend]]
DESCRIPTION
The xport function's main purpose is to write an XML formatted representation of the data stored in one or several RRDs. It can also
extract numerical reports.
If no XPORT statements are found, there will be no output.
-s|--start seconds (default end-1day)
The time when the exported range should begin. Time in seconds since epoch (1970-01-01) is required. Negative numbers are relative to
the current time. By default one day worth of data will be printed. See also AT-STYLE TIME SPECIFICATION section in the rrdfetch
documentation for a detailed explanation on how to specify time.
-e|--end seconds (default now)
The time when the exported range should end. Time in seconds since epoch. See also AT-STYLE TIME SPECIFICATION section in the rrdfetch
documentation for a detailed explanation of ways to specify time.
-m|--maxrows rows (default 400 rows)
This works like the -w|--width parameter of rrdgraph. In fact it is exactly the same, but the parameter was renamed to describe its
purpose in this module. See rrdgraph documentation for details.
--step value (default automatic)
See rrdgraph documentation.
--daemon address
Address of the rrdcached daemon. If specified, a "flush" command is sent to the server before reading the RRD files. This allows
rrdtool to return fresh data even if the daemon is configured to cache values for a long time. For a list of accepted formats, see the
-l option in the rrdcached manual.
rrdtool xport --daemon unix:/var/run/rrdcached.sock ...
--json
produce json formated output (instead of xml)
--enumds
The generated xml should contain the data values in enumerated tags.
<v0>val</v0><v1>val</v1>
DEF:vname=rrd:ds-name:CF
See rrdgraph documentation.
CDEF:vname=rpn-expression
See rrdgraph documentation.
XPORT:vname::legend
At least one XPORT statement should be present. The values referenced by vname are printed. Optionally add a legend.
Output format
The output is enclosed in an xport element and contains two blocks. The first block is enclosed by a meta element and contains some meta
data. The second block is enclosed by a data element and contains the data rows.
Let's assume that the xport command looks like this:
rrdtool xport
--start now-1h --end now
DEF:xx=host-inout.lo.rrd:output:AVERAGE
DEF:yy=host-inout.lo.rrd:input:AVERAGE
CDEF:aa=xx,yy,+,8,*
XPORT:xx:"out bytes"
XPORT:aa:"in and out bits"
The resulting meta data section is (the values will depend on the RRD characteristics):
<meta>
<start>1020611700</start>
<step>300</step>
<end>1020615600</end>
<rows>14</rows>
<columns>2</columns>
<legend>
<entry>out bytes</entry>
<entry>in and out bits</entry>
</legend>
</meta>
The resulting data section is:
<data>
<row><t>1020611700</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020612000</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020612300</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020612600</t><v>3.4113333333e+00</v><v>5.4581333333e+01</v></row>
<row><t>1020612900</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020613200</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020613500</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020613800</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020614100</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020614400</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020614700</t><v>3.7333333333e+00</v><v>5.9733333333e+01</v></row>
<row><t>1020615000</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020615300</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
<row><t>1020615600</t><v>NaN</v><v>NaN</v></row>
</data>
EXAMPLE 1
rrdtool xport
DEF:out=if1-inouts.rrd:outoctets:AVERAGE
XPORT:out:"out bytes"
EXAMPLE 2
rrdtool xport
DEF:out1=if1-inouts.rrd:outoctets:AVERAGE
DEF:out2=if2-inouts.rrd:outoctets:AVERAGE
CDEF:sum=out1,out2,+
XPORT:out1:"if1 out bytes"
XPORT:out2:"if2 out bytes"
XPORT:sum:"output sum"
ENVIRONMENT VARIABLES
The following environment variables may be used to change the behavior of "rrdtool xport":
RRDCACHED_ADDRESS
If this environment variable is set it will have the same effect as specifying the "--daemon" option on the command line. If both are
present, the command line argument takes precedence.
AUTHOR
Tobias Oetiker <tobi@oetiker.ch>
1.4.7 2012-01-16 RRDXPORT(1)