01-14-2014
Not clear. Where do you start you automating process? What should be the end result (yes, a .csv file, but what structure)? In which system (yes, EXCEL, but running where)?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies
2. Programming
hi,
iam reading the webpage using curl socket.
so iam geting the data in html format
so how can convert html data to text data ,so i can move forward.
thank u,
sree (3 Replies)
Discussion started by: phani_sree
3 Replies
3. Shell Programming and Scripting
I have a .csv file
equipment,bandtype
abc,aws
def,mmds
ghi,umts
jkl,mmds
I can get the equipment from `hostname`.
In my script i want to check what is the hostname. then see if it exists in the.csv file. if it does then i want to store the second parameter(bandtype) for the corresponding... (3 Replies)
Discussion started by: lassimanji
3 Replies
4. Linux
ID -------CODE-------DATE-------URL
I have a log file with entries like this. The file has about 6 lakhs record and the size is about 42MB. I need to covert them into a XML file like <ID></ID>
<CODE></CODE>
<DATE></DATE>
<URL></URL>
I have done a logic for this and successfully done.... (0 Replies)
Discussion started by: arunkumar.in
0 Replies
5. Shell Programming and Scripting
I have a script which has to be scheduled to run 3 times a day.
My script picks the required fields from logfile and stores the data in a.csv file.
Sample data.
my logfile contain:
0097A,0374D,100903,1519,00000606191
0097A,C88RA,100903,0724,00000606105
So the output of first execution... (3 Replies)
Discussion started by: shrima.pratima
3 Replies
6. Shell Programming and Scripting
Hello everybody,
Here is my problem, I don't know anything about shell programming and my boss is actually asking me to develop a shell script in order to get values in a csv file from a specific date.
Here is a sample of the csv file :
Date;Enchaînement;Titre;Libellé ;calendrier;Heure début;Heure... (11 Replies)
Discussion started by: freyr
11 Replies
7. Shell Programming and Scripting
Hi Experts,
I have created a table with columns as empname,empid,phone,shiftname. Now I am having a .csv file format which contains the shift datas of the employees. I have to fetch this file and compare with the table I created to send an alert to the specified user. (2 Replies)
Discussion started by: micky3112
2 Replies
8. Shell Programming and Scripting
Hallo Friends,
I need you help. My file has 5000 or so lines and currently looks like below(sample).
Service Type,Origin,Destination,Rate Per Minute,Minimum Charge,Time Based Rate,Time Based From Day,Time Based To Day,Time Based From Time,Time Based To Time,Destination Prefix List,,
VoIS... (3 Replies)
Discussion started by: kekanap
3 Replies
9. Shell Programming and Scripting
Hi
I am writing a shell script to parse a CSV file , in which i am facing a problem to separate the columns . Could some one help me with it.
IN301330/00001 pvavan kumar limited xyz@ttccpp.com
IN302148/00002 PRECIOUS SECURITIES (P) LTD viash@yahoo.co.in
IN300239/00000 CENTRE india... (8 Replies)
Discussion started by: nanduri
8 Replies
10. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
LEARN ABOUT NETBSD
atf-report
ATF-REPORT(1) BSD General Commands Manual ATF-REPORT(1)
NAME
atf-report -- transforms the output of atf-run to different formats
SYNOPSIS
atf-report [-o fmt1:path1 [.. -o fmtN:pathN]]
atf-report -h
DESCRIPTION
atf-report reads the output of atf-run and transforms it to different formats. Some of these are user-friendly and others are machine-
parseable, which opens a wide range of possibilities to analyze the results of a test suite's execution. See Output formats below for more
details on which these formats are.
In the first synopsis form, atf-report reads the output of atf-run through its standard input and, if no -o options are given, prints a user-
friendly report on its standard output using the 'ticker' format. If -o options are provided (more than one are allowed), they specify the
complete list of reports to generate. They are all generated simultaneously, and for obvious reasons, two reports cannot be written to the
same file. Note that the default output is suppressed when -o is provided.
In the second synopsis form, atf-report will print information about all supported options and their purpose.
The following options are available:
-h Shows a short summary of all available options and their purpose.
-o fmt:path Adds a new output format. fmt is one of the formats described later on in Output formats. path specifies where the report
will be written to. Depending on the chosen format, this may refer to a single file or to a directory. For those formats
that write to a single file, specifying a '-' as the path will redirect the report to the standard output.
Output formats
The following output formats are allowed:
csv A machine-parseable Comma-Separated Values (CSV) file. This file contains the results for all test cases and test programs. Test
cases are logged using the following syntax:
tc, duration, test-program, test-case, result[, reason]
The 'result' field for test cases is always one of 'passed', 'skipped' or 'failed'. The last two are always followed by a reason.
Test programs are logged with the following syntax:
tp, duration, test-program, result[, reason]
In this case, the 'result' can be one of: 'passed', which denotes test programs that ran without any failure; 'failed', which
refers to test programs in which one or more test cases failed; or 'bogus', which mentions those test programs that failed to exe-
cute by some reason. The reason field is only available in the last case.
The time required to execute each test case and test program is also provided. You should not rely on the order of the entries in
the resulting output.
ticker A user-friendly report that shows the progress of the test suite's execution as it operates. This type of report should always be
redirected to a virtual terminal, not a file, as it may use control sequences that will make the output unreadable in regular
files.
xml A report contained in a single XML file. Ideal for later processing with xsltproc(1) to generate nice HTML reports.
EXAMPLES
The most simple way of running a test suite is to pipe the output of atf-run through atf-report without any additional flags. This will use
the default output format, which is suitable to most users:
atf-run | atf-report
In some situations, it may be interesting to get a machine-parseable file aside from the standard report. This can be done as follows:
atf-run | atf-report -o csv:testsuite.csv -o ticker:-
Or if the standard report is not desired, thus achieving completely silent operation: atf-run | atf-report -o csv:testsuite.csv
SEE ALSO
atf-run(1), atf(7)
BSD
December 16, 2011 BSD