First, do you understand how to pass arguments to your script? Do you know what $1, $2 are inside your script?
Next, you need to know how to extract a specific line by number. I realize that the man pages of "sed" are confusing, so to get you going, try
Finally, you need to know how to extract the specific column you want, How will you do that? There are at least two general ways to approach that:
You could build a table that matches column names to a number. Your script would have something like
More flexible would be if your script looked up the desired index by examining the first line itself. A crude method:
There are more clever ways to do that - Google for "Awk Associative Arrays" and see if that gives you any ideas in this vein.
I hope this gets you started. Let's see you write some code and we can help you over the rough spots.
Hi all,
in my csv file it'll look like this, and of course it may have more columns
US to UK;abc-hq-jcl;multimedia
UK to CN;def-ny-jkl;standard
DE to DM;abc-ab-klm;critical
FD to YM;la-yr-tym;standard
HY to MC;la-yr-ytm;multimedia
GT to KJ;def-ny-jrt;critical
I would like to group... (4 Replies)
Hi I have a csv file which is below
A,5
B,6
C,10
D,7
I want the values who's second column is greater than 7
say
C,10
D,7
Help me please...
Thanks,
Maruth (3 Replies)
hi, someone to know how can i read a specific column of csv file and search the value in other csv columns if exist the value in the second csv copy entire row with all field in a new csv file. i suppose that its possible using awk but i m not expertise thanks in advance (8 Replies)
Is there a way to read in a two-columned CSV file, and based on the fields in 1st column, output many different files? The input/output looks something like:
input.csv:
call Call Mom.
call Call T-Mobile.
go Go home.
go Go to school.
go Go to gas station.
play Play music.
play Play... (4 Replies)
My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated.
Main imp point, in my .csv file, third column is having price value with comma (1,20,300), it has... (2 Replies)
I have a .CSV file with the below format:
"column 1","column 2","column 3","column 4","column 5","column 6","column 7","column 8","column 9","column 10
"12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""... (2 Replies)
input.csv:
Field1,Field2,Field3,Field4,Field4
abc ,123 ,xyz ,000 ,pqr
mno ,123 ,dfr ,111 ,bbb
output:
Field2,Field4
123 ,000
123 ,111
how to fetch the values of Field4 where Field2='123'
I don't want to fetch the values based on column position. Instead want to... (10 Replies)
Hi,
I am having below two CSV's
col_1,col_2,col_3
1,2,4
1,3,6
col_1,col_3,col2,col_5,col_6
1,2,3,4,5
1,6,3,,,
I need to compare based on the columns where the mismatch is
expected output
col_1,col_2,col_3
1,2,4 (3 Replies)
Hello everyone,
I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this:
20170628-23:25:01,1,0,0,1,1,1,1,55,55,1
20170628-23:30:01,1,0,0,1,1,1,1,56,56,1
20170628-23:35:00,1,0,0,1,1,2,1,57,57,2
20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Hi,
I tried filtering the records in a csv file using "awk" command listed below.
awk -F"~" '$4 ~ /Active/{print }' inputfile > outputfile
The output always has all the entries.
The same command worked for different users from one of the forum links.
content of file I was... (3 Replies)
Discussion started by: sunilmudikonda
3 Replies
LEARN ABOUT DEBIAN
rdf::trine::exporter::csv
RDF::Trine::Exporter::CSV(3pm) User Contributed Perl Documentation RDF::Trine::Exporter::CSV(3pm)NAME
RDF::Trine::Exporter::CSV - Export RDF data to CSV
VERSION
This document describes RDF::Trine::Exporter::CSV version 1.000
SYNOPSIS
use RDF::Trine::Exporter::CSV;
DESCRIPTION
The RDF::Trine::Exporter::CSV class provides an API for serializing RDF data to CSV strings and files.
METHODS
"new ( sep_char => $sep_char, quote => $bool )"
Returns a new RDF::Trine::Exporter::CSV object. If $sep_char is provided, it is used as the separator character in CSV serialization,
otherwise a comma (",") is used.
"serialize_iterator_to_file ( $file, $iterator )"
Serializes the bindings objects produced by $iterator, printing the results to the supplied filehandle "<$fh">.
"serialize_iterator_to_string ( $iterator )"
Serializes the bindings objects produced by $iterator, returning the result as a string.
BUGS
Please report any bugs or feature requests to through the GitHub web interface at <https://github.com/kasei/perlrdf/issues>.
AUTHOR
Gregory Todd Williams "<gwilliams@cpan.org>"
COPYRIGHT
Copyright (c) 2006-2012 Gregory Todd Williams. This program is free software; you can redistribute it and/or modify it under the same terms
as Perl itself.
perl v5.14.2 2012-06-29 RDF::Trine::Exporter::CSV(3pm)