|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Perl: adding columns in CSV file with information in each
Post 302172851 by dolo21taf on Wednesday 5th of March 2008 12:11:35 AM
03-05-2008
Perl: adding columns in CSV file with information in each
Hi Wise UNIX Crew,
I want to add 3 different columns to the file in which:
1. The first new column pulls in today's date and time
2. Second column one has a '0'
3. Third column has the word 'ANY' going down the column
If my file content is as follows:
"7","a","abc",123"
"8","b","cde","456"
"9","c","fgh","789"
This is what I want the file content to be:
"2008-04-03 10:33:08",0,ANY,"7","a","abc",123"
"2008-04-03 10:33:08",0,ANY,"8","b","cde","456"
"2008-04-03 10:33:08",0,ANY,"9","c","fgh","789"
Big brownie points in advance......and a bigger thanks
S
I want to add 3 different columns to the file in which:
1. The first new column pulls in today's date and time
2. Second column one has a '0'
3. Third column has the word 'ANY' going down the column
If my file content is as follows:
"7","a","abc",123"
"8","b","cde","456"
"9","c","fgh","789"
This is what I want the file content to be:
"2008-04-03 10:33:08",0,ANY,"7","a","abc",123"
"2008-04-03 10:33:08",0,ANY,"8","b","cde","456"
"2008-04-03 10:33:08",0,ANY,"9","c","fgh","789"
Big brownie points in advance......and a bigger thanks
S
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How do I add 4 columns to an excel file using Perl? The 4 headers for those columns will all have different names? Please help and I greatly appreciate... (1 Reply)
Discussion started by: dolo21taf
1 Replies
2. UNIX for Advanced & Expert Users
I have the following data in FILE1.CSV:
code: Amount1: Amount2:
xxxxx ,, 200 ,,400
yyxxa ,,200
bbcgu ,,2500 ,,300
i want to be able to produce the following FILE2.CSV:
code: Amount
xxxxx ,, 600... (7 Replies)
Discussion started by: chachabronson
7 Replies
3. Shell Programming and Scripting
Hi Everyone:
My shell script creates multiple csv files (~30) in for loop. I want to compile (or merge) 3rd column from each (all) of these files to another file (in loop). Please help. Thanks. (3 Replies)
Discussion started by: smap007
3 Replies
4. UNIX for Advanced & Expert Users
Hi All,
I have two .csv's
input.csv having values as (7 columns)
ABC,A19907103,ABC DEV YUNG,2.17,1000,2157,07/07/2006
XYZ,H00213850,MM TRUP HILL,38.38,580,23308,31/08/2010
output.csv having (25 columns)
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y... (4 Replies)
Discussion started by: abhivyas
4 Replies
5. Programming
Hi,
I have c file which contains more number of tests. two or more tests in one c file. I have the XMl data regarding tests. i need to add this xml data to c file at before the test. I know which file having which test and i created hash table for that. so the problem is i have to add information... (13 Replies)
Discussion started by: veerubiji
13 Replies
6. UNIX for Advanced & Expert Users
Hi All,
i have a .Csv file in the below format
startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies
7. UNIX for Dummies Questions & Answers
I have a file in which I need to add more columns to based on a key in the first file:
File1
key1,abc,123,
key2,def,456,
key3,ghi,789,
File2
key2,zyx,111,qqq,
key3,yuu,222,www,
key1,pui,333,eee,
key4,xxx,999,rrr,
I would like to create the following output:
Output (1 Reply)
Discussion started by: WongSifu
1 Replies
8. 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
9. Shell Programming and Scripting
Hello everyone,
want to merge 2 last columns 3rd and 4rd (if it exists).
I have this
1;2;1;1
2;3;1;1
1;1;2
1;2;3;4
1;1;2
1;2;3;1
Desired output:
1;2;1 1
2;3;1 1
1;1;2
1;2;3 4
1;1;2
1;2;3 1 (3 Replies)
Discussion started by: satir
3 Replies
10. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
LEARN ABOUT DEBIAN
mrtg-ping-probe
MRTG-PING-PROBE(1) General Commands Manual MRTG-PING-PROBE(1) NAME
mrtg-ping-probe - ping probe module for Multi Router Traffic Grapher DESCRIPTION
mrtg-ping-probe is a ping probe module for MRTG 2.x. It is used to monitor the round trip time and packet loss to networked devices. MRTG uses the output of mrtg-ping-probe to generate graphs visualizing minimum and maximum round trip times or packet loss. mrtg-ping-probe is not run directly, but is called by MRTG as a helper when it needs to determine ping time to a host. Act responsibly: do not use mrtg-ping-probe to ping devices without the owner's permission. Just imagine if 10,000 people decided to ping your hosts! mrtg-ping-probe is meant to be used within your network to get round trip time performance figures for your network. OPTIONS
To use mrtg-ping-probe you need to configure MRTG to call it from within the definition of a target host. This is done in the MRTG config file, which is usually /etc/mrtg.conf. Here's an example snippet: change the target name and IP address to suit your needs. Target[your.target.ping]: `/usr/bin/mrtg-ping-probe 123.456.789.123` SetEnv[your.target.ping]: MRTG_INT_IP="123.456.789.123" MRTG_INT_DESCR="ping" MaxBytes[your.target.ping]: 100 AbsMax[your.target.ping]: 200 Options[your.target.ping]: gauge, growright YLegend[your.target.ping]: ping time (ms) ShortLegend[your.target.ping]: ms Legend1[your.target.ping]: Maximum Round Trip Time in ms Legend2[your.target.ping]: Minimum Round Trip Time in ms Legend3[your.target.ping]: Maximal 5 Minute Maximum Round Trip Time in ms Legend4[your.target.ping]: Maximal 5 Minute Minimum Round Trip Time in ms LegendI[your.target.ping]: Max: LegendO[your.target.ping]: Min: Pay close attention to the backticks in the first line which tell MRTG to execute the nominated external program. Note also that you need to use the "gauge" option, since the results of subsequent ping probes are independant values and not an incrementing counter. SEE ALSO
mrtg(1). The latest release of mrtg-ping-probe can be found on the web at http://pwo.de/projects/mrtg/ AUTHOR
This manual page was written by Jonathan Oxer <jon@debian.org>, for the Debian project (but may be used by others). April 14, 2003 MRTG-PING-PROBE(1)