Sponsored Content
Top Forums Shell Programming and Scripting If condition satisfies print the column header Post 302803093 by Fredrick on Monday 6th of May 2013 02:45:54 AM
Old 05-06-2013
Sorry, Could you please explain me.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

need to read a file and keep waiting till it satisfies some condition

In my script i am writing to a counter file the no of processes i had started, that is each time i start a process, i will increment the content of counter file and also when the process ends i will decrement the content of the file. after this i do some other activities, by now i want to... (1 Reply)
Discussion started by: senthilk615
1 Replies

2. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies

3. Shell Programming and Scripting

Filter the column and print the result based on condition

Hi all This is my output of the some SQL Query TABLESPACE_NAME FILE_NAME TOTALSPACE FREESPACE USEDSPACE Free ------------------------- ------------------------------------------------------- ---------- --------- ---------... (2 Replies)
Discussion started by: jhon
2 Replies

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

5. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

6. Shell Programming and Scripting

write a matrix element, if the "if" condition satisfies

Hi All, I would like to check a condition in a nxm matrix and if the condition satisfies then, I need to write the matrix element in the output file. For example, I have a matrix like this: 1 2 3 4 5 2 3 4 5 1 3 4 5 1 ... (8 Replies)
Discussion started by: Fredrick
8 Replies

7. Shell Programming and Scripting

Add column header and row header

Hi, I have an input like this 1 2 3 4 2 3 4 5 4 5 6 7 I would like to count the no. of columns and print a header with a prefix "Col". I would also like to count the no. of rows and print as first column with each line number with a prefix "Row" So, my output would be ... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

8. Shell Programming and Scripting

Print column header

Hi, Below is the data in a tab limited file Here ACCENT is just a heading and the line starting with Pcode has the column headers, and there is a 2 lines space between the file header and column header. I want to print $2, that is Dealer Name I used the below code nawk... (1 Reply)
Discussion started by: kedar_laveti
1 Replies

9. Shell Programming and Scripting

Print the column content based on the header

i have a input of csv file as below but the sequence of column get changed. I,e it is not necessary that name comes first then age and rest all, it may vary. name,age,marks,roll,section kevin,25,80,456,A Satch,23,56,789,B Meena,24,78,H245,C So i want to print that column entires which... (12 Replies)
Discussion started by: millan
12 Replies

10. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
MongoDB::Cursor(3pm)					User Contributed Perl Documentation				      MongoDB::Cursor(3pm)

NAME
MongoDB::Cursor - A cursor/iterator for Mongo query results SYNOPSIS
while (my $object = $cursor->next) { ... } my @objects = $cursor->all; Multithreading Cloning instances of this class is disabled in Perl 5.8.7+, so forked threads will have to create their own database queries. SEE ALSO
Core documentation on cursors: <http://dochub.mongodb.org/core/cursors>. STATIC ATTRIBUTES
slave_okay $MongoDB::Cursor::slave_okay = 1; Whether it is okay to run queries on the slave. Defaults to 0. timeout Deprecated, use MongoDB::Connection::query_timeout instead. How many milliseconds to wait for a response from the server. Set to 30000 (30 seconds) by default. -1 waits forever (or until TCP times out, which is usually a long time). This value is overridden by "MongoDB::Connection::query_timeout" and never used. ATTRIBUTES
started_iterating If this cursor has queried the database yet. Methods mofifying the query will complain if they are called after the database is queried. immortal $cursor->immortal(1); Ordinarily, a cursor "dies" on the database server after a certain length of time (approximately 10 minutes), to prevent inactive cursors from hogging resources. This option sets that a cursor should not die until all of its results have been fetched or it goes out of scope in Perl. Boolean value, defaults to 0. "immortal" is not equivalent to setting a client-side timeout. If you are getting client-side timeouts (e.g., "recv timed out"), set "query_timeout" on your connection. # wait forever for a query to return results $connection->query_timeout(-1); See "query_timeout" in MongoDB::Connection. tailable $cursor->tailable(1); If a cursor should be tailable. Tailable cursors can only be used on capped collections and are similar to the "tail -f" command: they never die and keep returning new results as more is added to a collection. They are often used for getting log messages. Boolean value, defaults to 0. partial If a shard is down, mongos will return an error when it tries to query that shard. If this is set, mongos will just skip that shard, instead. Boolean value, defaults to 0. slave_okay $cursor->slave_okay(1); If a query can be done on a slave database server. Boolean value, defaults to 0. METHODS
fields (\%f) $coll->insert({name => "Fred", age => 20}); my $cursor = $coll->query->fields({ name => 1 }); my $obj = $cursor->next; $obj->{name}; "Fred" $obj->{age}; # undef Selects which fields are returned. The default is all fields. _id is always returned. sort ($order) # sort by name, descending my $sort = {"name" => -1}; $cursor = $coll->query->sort($sort); Adds a sort to the query. Argument is either a hash reference or a Tie::IxHash. Returns this cursor for chaining operations. limit ($num) $per_page = 20; $cursor = $coll->query->limit($per_page); Returns a maximum of N results. Returns this cursor for chaining operations. skip ($num) $page_num = 7; $per_page = 100; $cursor = $coll->query->limit($per_page)->skip($page_num * $per_page); Skips the first N results. Returns this cursor for chaining operations. See also core documentation on limit: <http://dochub.mongodb.org/core/limit>. snapshot my $cursor = $coll->query->snapshot; Uses snapshot mode for the query. Snapshot mode assures no duplicates are returned, or objects missed, which were present at both the start and end of the query's execution (if an object is new during the query, or deleted during the query, it may or may not be returned, even with snapshot mode). Note that short query responses (less than 1MB) are always effectively snapshotted. Currently, snapshot mode may not be used with sorting or explicit hints. hint my $cursor = $coll->query->hint({'x' => 1}); Force Mongo to use a specific index for a query. explain my $explanation = $cursor->explain; This will tell you the type of cursor used, the number of records the DB had to examine as part of this query, the number of records returned by the query, and the time in milliseconds the query took to execute. Requires boolean package. "explain" resets the cursor, so calling "next" or "has_next" after an explain will requery the database. See also core documentation on explain: <http://dochub.mongodb.org/core/explain>. count($all?) my $num = $cursor->count; my $num = $cursor->skip(20)->count(1); Returns the number of document this query will return. Optionally takes a boolean parameter, indicating that the cursor's limit and skip fields should be used in calculating the count. reset Resets the cursor. After being reset, pre-query methods can be called on the cursor (sort, limit, etc.) and subsequent calls to next, has_next, or all will re-query the database. has_next while ($cursor->has_next) { ... } Checks if there is another result to fetch. next while (my $object = $cursor->next) { ... } Returns the next object in the cursor. Will automatically fetch more data from the server if necessary. Returns undef if no more data is available. info Returns a hash of information about this cursor. Currently the fields are: "cursor_id" The server-side id for this cursor. A "cursor_id" of 0 means that there are no more batches to be fetched. "num" The number of results returned so far. "at" The index of the result the cursor is currently at. "flag" If the database could not find the cursor or another error occurred, "flag" may be set (depending on the error). See http://www.mongodb.org/display/DOCS/Mongo+Wire+Protocol#MongoWireProtocol-OPREPLY <http://www.mongodb.org/display/DOCS/Mongo+Wire+Protocol#MongoWireProtocol-OPREPLY> for a full list of flag values. "start" The index of the result that the current batch of results starts at. all my @objects = $cursor->all; Returns a list of all objects in the result. AUTHOR
Kristina Chodorow <kristina@mongodb.org> perl v5.14.2 2011-09-07 MongoDB::Cursor(3pm)
All times are GMT -4. The time now is 01:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy