02-19-2009
You rick. That's perfect. I knew awk was the answer but I'm new to unix scripting so didn't know how to get there. Thanks again!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
2. Shell Programming and Scripting
I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column.
I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this?
Sample input
02/27/09,23:52:31
02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies
3. Shell Programming and Scripting
I have a csv file which I need to process and export back to xlsx file.
For instance, the csv contains:
John Smith, job-title, hours
John Smith, job-title, hours
Mary Smith job-title, hours
etc.
I need to import that to a script, get id of redundant data i.e:
John smith, job-title,... (13 Replies)
Discussion started by: _tina_
13 Replies
4. Shell Programming and Scripting
hi there
I have file names in different format as below
triss_20111117_fxcb.csv
triss_fxcb_20111117.csv
xpnl_hypo_reu_miplvdone_11172011.csv
xpnl_hypo_reu_miplvdone_11-17-2011.csv
xpnl_hypo_reu_miplvdone_20111117.csv
xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies
5. Shell Programming and Scripting
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
6. Shell Programming and Scripting
I have a CSV file with a date format like this;
11/19/2012 17:37:00,1.372,121.6
11/19/2012 17:38:00,0.743,121.6
Want to change the time stamp to seconds after 1970 so I can get the data in rrdtool. For anyone interested, this is data from a TED5000 unit and is Kwatts and volts.
Needs to... (3 Replies)
Discussion started by: ottsm
3 Replies
7. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
8. Shell Programming and Scripting
Example:
Input csv file
00245DLS,Sitel Ocala,12/31/2014,18:45,1.00,7.00,0.00,0.00
00245DLS,Sitel Ocala,12/31/2014,19:00,-1.00,-1.00,-1.00,-1.00
00245HB,Charlotte,01/01/2015,00:00,-1.00,-1.00,-1.00,0.00
Output csv file
00245DLS,Sitel Ocala,2014/12/31,18:45,1.00,7.00,0.00,0.00
00245DLS,Sitel... (8 Replies)
Discussion started by: adit
8 Replies
9. Shell Programming and Scripting
Hi,
We have csv file where date is coming in MM/DD/YYYY HH:MM:SS (06/23/2015 20:59:12) in multiple places
But we need to change the date format to DD/Mon/YYYY HH:MM:SS (23/Jul/2015 20:59:12) using shell script.
Please let us know how can we achieve the same. (16 Replies)
Discussion started by: dholea
16 Replies
10. Shell Programming and Scripting
Hi All,
I'm new to forum good to hear all.
I stuck in converting date format in csv file using unix
csv file contains as below
,750,0000000000000000GCJR, ,06/22/2016 14:48:44
I want to convert into as below
,750,0000000000000000GCJR, ,06/22/2016 02:48:44 PM
Please reply asap..... (22 Replies)
Discussion started by: Raghureds
22 Replies
LEARN ABOUT DEBIAN
mrtg-faq
MRTG-FAQ(1) mrtg MRTG-FAQ(1)
NAME
mrtg-faq - How to get help if you have problems with MRTG
SYNOPSIS
MRTG seems to raise a lot of questions. There are a number of resources apart from the documentation where you can find help for mrtg.
FAQ
In the following sections you'll find some additonal Frequently Asked Questions, with Answers.
Why is there no "@#$%" (my native language) version of MRTG?
Nobody has contributed a @#$%.pmd file yet. Go into the mrtg-2.17.4/translate directory and create your own translation file. When you are
happy with it send it to me for inclusion with the next mrtg release.
I need a script to make mrtg work with my xyz device.
Probably this has already been done. Check the stuff in the mrtg-2.17.4/contrib directory. There is a file called 00INDEX in that directory
which tells what you can find in there.
How does this SNMP thing work
There are many resources on the net that explain SNMP. Take a look at this article from the Linux Journal by David Guerrero
http://www.david-guerrero.com/papers/snmp/
And at this rather long document from CISCO.
http://www.cisco.com/univercd/cc/td/doc/cisintwk/ito_doc/snmp.htm
The images created by MRTG look very strange.
Remove the *-{week,day,month,year}.png files and start MRTG again. Using MRTG for the first time, you might have to do this twice. This
will also help when you introduce new routers into the cfg file.
What is my Community Name?
Ask the person in charge of your Router or try 'public', as this is the default Community Name.
My graphs show a flat line during an outage. Why ?
Well, the short answer is that when an SNMP query goes out and a response doesn't come back, MRTG has to assume something to put in the
graph, and by default it assumes that the last answer we got back is probably closer to the truth than zero. This assumption is not
perfect (as you have noticed). It's a trade-off that happens to fail during a total outage.
If this is an unacceptable trade-off, use the unknaszero option.
You may want to know what you're trading off, so in the spirit of trade-offs, here's the long answer:
The problem is that MRTG doesn't know *why* the data didn't come back, all it knows is that it didn't come back. It has to do something,
and it assumes it's a stray lost packet rather than an outage.
Why don't we always assume the circuit is down and use zero, which will (we think) be more nearly right? Well, it turns out that you may
be taking advantage of MRTG's "assume last" behaviour without being aware of it.
MRTG uses SNMP (Simple Network Management Protocol) to collect data, and SNMP uses UDP (User Datagram Protocol) to ship packets around.
UDP is connectionless (not guaranteed) unlike TCP where packets are tracked and acknowledged and, if needed, retransmitted. UDP just
throws packets at the network and hopes they arrive. Sometimes they don't.
One likely cause of lost SNMP data is congestion; another is busy routers. Other possibilities include transient telecommunications
problems, router buffer overflows (which may or may not be congestion-related), "dirty lines" (links with high error rates), and acts of
God. These things happen all the time; we just don't notice because many interactive services are TCP-based and the lost packets get
retransmitted automatically.
In the above cases where some SNMP packets are lost but traffic is flowing, assuming zero is the wrong thing to do - you end up with a
graph that looks like it's missing teeth whenever the link fills up. MRTG interpolates the lost data to produce a smoother graph which is
more accurate in cases of intermittent packet loss. But with V2.8.4 and above, you can use the "unknaszero" option to produce whichever
graph is best under the conditions typical for your network.
AUTHOR
Tobias Oetiker <tobi@oetiker.ch>
2.17.4 2012-01-12 MRTG-FAQ(1)