Hi,
I am trying to replace a specific column values in a csv file with double quotes.
Example:
SNO,NAME,ZIPCODE,RANK
1,Robert,74538,12
2,Sam,07564,13
3,Kim, Ed,12345,14
Desired Output:
SNO,NAME,ZIPCODE,RANK
1,Robert Ken,74538,12
2,Sam Mik,"07564",13
3,"Kim, Ed",12345,14
I... (3 Replies)
I have a CSV file that is missing quotes around a column that contains text with commas. Example:
Column1, Column2, Column3, Column4, Column5, Column6
Data1, Data2, Data3, Data, 4, Data5, Data6
Data1, Data3, Data3, Data, text, 4, Data5, Data6
I think the easiest way for me to fix this is to... (2 Replies)
Hello,
I need to read a csv file and I am trying to replace a comma with a text DSEE?DSEE.
Example
Input
"Chapter","NewTrains, "oldTrains","Delayed",10,"London"
"Chapter","Newbuses,oldbuses","On Time",20,"London"
Output
"Chapter","NewTrainsDSEE?DSEE... (5 Replies)
I saved the csv file in a comma delimited format.
Sample input
input.csv
1 abc 2
2 def 4
3 ghi 6
4 jkl 8
5 mno 10
output.csv should look like this with single quotes around each field
'1' 'abc' '2'
'2' 'def' '4'
'3' 'ghi' '6'
'4' 'jkl' '8'
'5' 'mno' '10'
Please help me :confused:... (3 Replies)
Hi List,
I am sure this issue must have been encountered before. I have saved an excel CSV and sent it to my linux box where I require to parse it as a CSV line by line. The file displays fine in Excel with csv headers and consistent records and fields. However when I look at it in linux I see... (2 Replies)
Hello experts,
I need to validate a csv file which contains data like this:
Sample.csv
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
I just need to check if all the records contain exactly the number of... (5 Replies)
I have a csv data file :
A,B,C,D,"A,B",E,"GG,H"
E,F,G,H,I,J,"S,P"
I need to replace all "," with "|" except the ones between double quotes i.e
A|B|C|D|"A,B"|E|"GG,H"
E|F|G|H|I|J|"S,P"
CAn someone assist? (8 Replies)
Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote.
Please see the sample file as below:
column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10... (8 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Hi All,
I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes.
Sample Data :
"221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 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