hi everybody
i would to select the last field of a file
here as you can see i select the field number 8
y=`cat sortie2 | grep "^"| grep "starting"| awk '{ print $8}'`
but line can containt more or less field in never know, i just know is the last one
so i wondering to know if is... (3 Replies)
Hi
I have a Fixed format data file where I need to to get the total of the field at certain position in a file for a group of lines.
In this data file I need the total of all the field ats position 30:39 for each line starting with 6 and for each group startign with 5. Which means for... (27 Replies)
Hi,
Suppose if i am having a file with following records as given below.
5555
6756
5555
4555
4555
6767
how can i get the count of each record using AWK.
Eg:5555 count should be 2
4555 count should be 2
6767 count should be 1
... (5 Replies)
Hi Everyone,
I am facing a problem regarding the select from sybase, the return with the incorrect size.
For example, field is NAME(20).
After i selected from sybase, the result is nicky.
after i assign it to another declaration variable, it will be in actual name "nicky" , what i need... (10 Replies)
For a field format such as AAL1001_MD82, how do I select(and use in if statement) only the last four elements( in this case MD82) or the first three elements (in this case AAL)?
For instance, how do I do the following - if first three elements of $x == yyy, then ... (5 Replies)
When parsing multiple fields in a file using AWK, how do you group by one of the fields and parse by delimiters?
to clarify
If a file had
tom | 223-2222-4444 , randofield
ivan | 123-2422-4444 , random filed
... | and , are the delimiters ...
How would you group by the social security... (4 Replies)
Hi Team,
I have a requirement to login into URL using username and password , then I have to select a "particular name" from drop-down menu and then Read the values user records etc.... using perl.
Is it possible to do in perl script ? (OR) Can you please let me know which scripting... (1 Reply)
Hi,
I saw your post..
I have a dought in awk command...
how to get the output from a file. i need a first column in etc/passwd file in a single column (in indivijual line)...
i couldn't get with this command
cat /etc/passwd | awk -F ":" '{printf $1}'
Kindly help
This thread was created... (3 Replies)
Hello
I have a large file1 which has many events like "2014010420" and following lines under each event that start with text . It has this form:
2014010420 num --- --- num ....
NTE num num --- num...
EFA num num --- num ...
LASW num num --- num... (9 Replies)
Discussion started by: phaethon
9 Replies
LEARN ABOUT DEBIAN
rdf::query::compiler::sql
RDF::Query::Compiler::SQL(3pm) User Contributed Perl Documentation RDF::Query::Compiler::SQL(3pm)NAME
RDF::Query::Compiler::SQL - Compile a SPARQL query directly to SQL.
VERSION
This document describes RDF::Query::Compiler::SQL version 2.908.
METHODS
"new ( $parse_tree )"
Returns a new compiler object.
"compile ()"
Returns a SQL query string for the specified parse tree.
"emit_select"
Returns a SQL query string representing the query.
"limit_clause"
Returns a SQL LIMIT clause, or an empty string if the query does not need limiting.
"order_by_clause"
Returns a SQL ORDER BY clause, or an empty string if the query does not use ordering.
"variable_columns ( $var )"
Given a variable name, returns the set of column aliases that store the values for the column (values for Literals, URIs, and Blank
Nodes).
"add_variable_values_joins"
Modifies the query by adding LEFT JOINs to the tables in the database that contain the node values (for literals, resources, and blank
nodes).
"patterns2sql ( @triples, $level, %args )"
Builds the SQL query in instance data from the supplied @triples. $level is used as a unique identifier for recursive calls.
%args may contain callback closures for the following keys:
'where_hook'
'from_hook'
When present, these closures are used to add SQL FROM and WHERE clauses to the query instead of adding them directly to the object's
instance data.
"expr2sql ( $expression, $level, %args )"
Returns a SQL expression for the supplied query $expression. $level is used as a unique identifier for recursive calls.
%args may contain callback closures for the following keys:
'where_hook'
'from_hook'
When present, these closures are used to add necessary SQL FROM and WHERE clauses to the query.
"_mysql_hash ( $data )"
Returns a hash value for the supplied $data string. This value is computed using the same algorithm that Redland's mysql storage
backend uses.
"_mysql_node_hash ( $node )"
Returns a hash value (computed by "_mysql_hash" for the supplied $node. The hash value is based on the string value of the node and
the node type.
"qualify_uri ( $uri )"
Returns a fully qualified URI from the supplied $uri. $uri may already be a qualified URI, or a parse tree for a qualified URI or
QName. If $uri is a QName, the namespaces defined in the query parse tree are used to fully qualify.
"add_function ( $uri, $function )"
Associates the custom function $function (a CODE reference) with the specified URI, allowing the function to be called by query
FILTERs.
"get_function ( $uri )"
If $uri is associated with a query function, returns a CODE reference to the function. Otherwise returns "undef".
AUTHOR
Gregory Williams <gwilliams@cpan.org>
perl v5.14.2 2012-01-31 RDF::Query::Compiler::SQL(3pm)