07-29-2013
Check for rows with particular string
Hi. The data file is as below:
2000922111111100232091212098324....
2123011230912832094820943684896....
3435983453409583405938453049583....
.
.
.
I need to get only the rows that match my criteria. For example: those at characters 5-10 should equal to "922111" (thus getting only the 1st row above).
As my script processes a lot of these files, I only need to check for this string first before I run succeeding codes to minimize run time. An "if-cut" condition should work but I don't want to do this per line (again, due to run time considerations).
Hope you can help me with an alternative solution.
Thanks!!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I would like to append a string at the end of each row of a .dat file.
please give me some advice? Thanks.
e.g.
#content in abc.dat
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
...
#after running the script/command,... (7 Replies)
Discussion started by: Rock
7 Replies
2. Shell Programming and Scripting
Hello All,
Plz help me with:
I have a csv file with data separated by ',' and optionally enclosed by "". I want to check each of these values to see if they exceed the specified string length, and if they do I want to cut just that value to the max length allowed and keep the csv format as it... (9 Replies)
Discussion started by: ozzy80
9 Replies
3. Shell Programming and Scripting
Hello,
i have a file "Movie.ini" looking e.g. like follows
* MOVIE A
bla bla
MOVIE B
blubb blubb
MOVIE C
I'd like to read the file "Movie.ini" with cat and grep and check whether it includes the string MOVIE only with a '*' at the beginnig.
By doing
"cat Movie.ini| grep MOVIE... (14 Replies)
Discussion started by: ABE2202
14 Replies
4. Shell Programming and Scripting
I'm getting the input row in this format it contains 2 alphabets followed by numbers between 1 and 7 and again 2 alphabets followed by numbers between 1 and 7.
Now I need to parse this input into several output rows in this format 2 alphabets followed by each number occurrence
suppose... (5 Replies)
Discussion started by: abhijith321
5 Replies
5. UNIX Desktop Questions & Answers
1)I need to write a script which ftps 3 files to a unix box,
2)once the files are ftped i need to check the number of rows in each file and compare it with the data (no of rows) coming in a manifest file, if the number of rows in each file matches the data coming in manifest file, then i need to... (3 Replies)
Discussion started by: imran_affu
3 Replies
6. Shell Programming and Scripting
Hi,
Would anyone be able to tell me how to check the number of rows in an excel sheet on unix box, please?
Cheers,
Girish. (2 Replies)
Discussion started by: girish1428
2 Replies
7. Shell Programming and Scripting
Hi am using unix aix
I have tried using awk but am getting only output = x ,its not incrementing next output
set -A var1 vv qa za
ct=0
i=3
while
do
var1=`echo ${var1}`
count=`awk ' NR==$i++ {print;exit}' ${.txt} | cut -c5 `
echo $count
let ct=ct+1
done (6 Replies)
Discussion started by: Venkatesh1
6 Replies
8. Shell Programming and Scripting
I want to append file with a string but before doing that i want to check if this string already exist in that file.I tried with grep on Solaris 10 but unsuccessful.Man pages from grep seems to suggest if the string is found command status will be 0 and if not 1.But i am not finding it.May be i... (2 Replies)
Discussion started by: sahil_shine
2 Replies
9. Shell Programming and Scripting
Hi,
I have file with values as below
1~ab~456~ac:bd:de:ef~yyyy-mm-dd
2~cd~458~af:fg:ty:er:ty:uj:io:~yyyy-mm-dd
I want the o/p as for frist row
1~ab~456~ac~yyyy-mm-dd
1~ab~456~bd~yyyy-mm-dd
1~ab~456~de~yyyy-mm-dd
1~ab~456~ef~yyyy-mm-dd
and for the second row
2~cd~458~af~yyyy-mm-dd... (4 Replies)
Discussion started by: rithushri
4 Replies
10. Shell Programming and Scripting
Hi,
I have a requirement that has 50-60 million records that we need to split a delimited string (Delimeter is newline) into rows.
Source Date:
SerialID UnidID GENRE
100 A11 AAAchar(10)BBB
200 B11 CCCchar(10)DDD(10)ZZZZ
Field 'GENRE' is a string with new line as delimeter and not sure... (5 Replies)
Discussion started by: techmoris
5 Replies
LEARN ABOUT DEBIAN
netsnmp_row_merge
row_merge(3snmp) net-snmp row_merge(3snmp)
NAME
row_merge -
Calls sub handlers with request for one row at a time.
Defines
#define ROW_MERGE_WAITING 0
#define ROW_MERGE_ACTIVE 1
#define ROW_MERGE_DONE 2
#define ROW_MERGE_HEAD 3
Functions
netsnmp_mib_handler * netsnmp_get_row_merge_handler (int prefix_len)
returns a row_merge handler that can be injected into a given handler chain.
int netsnmp_register_row_merge (netsnmp_handler_registration *reginfo)
functionally the same as calling netsnmp_register_handler() but also injects a row_merge handler at the same time for you.
netsnmp_row_merge_status * netsnmp_row_merge_status_get (netsnmp_handler_registration *reginfo, netsnmp_agent_request_info *reqinfo, int
create_missing)
retrieve row_merge_status
int netsnmp_row_merge_status_first (netsnmp_handler_registration *reginfo, netsnmp_agent_request_info *reqinfo)
Determine if this is the first row.
int netsnmp_row_merge_status_last (netsnmp_handler_registration *reginfo, netsnmp_agent_request_info *reqinfo)
Determine if this is the last row.
int netsnmp_row_merge_helper_handler (netsnmp_mib_handler *handler, netsnmp_handler_registration *reginfo, netsnmp_agent_request_info
*reqinfo, netsnmp_request_info *requests)
Implements the row_merge handler.
void netsnmp_init_row_merge (void)
initializes the row_merge helper which then registers a row_merge handler as a run-time injectable handler for configuration file use.
Detailed Description
Calls sub handlers with request for one row at a time.
This helper splits a whole bunch of requests into chunks based on the row index that they refer to, and passes all requests for a given row
to the lower handlers. This is useful for handlers that don't want to process multiple rows at the same time, but are happy to iterate
through the request list for a single row.
Function Documentation
netsnmp_mib_handler* netsnmp_get_row_merge_handler (int prefix_len)
returns a row_merge handler that can be injected into a given handler chain.
Definition at line 28 of file row_merge.c.
void netsnmp_init_row_merge (void)
initializes the row_merge helper which then registers a row_merge handler as a run-time injectable handler for configuration file use.
Definition at line 360 of file row_merge.c.
int netsnmp_register_row_merge (netsnmp_handler_registration * reginfo)
functionally the same as calling netsnmp_register_handler() but also injects a row_merge handler at the same time for you.
Definition at line 42 of file row_merge.c.
int netsnmp_row_merge_helper_handler (netsnmp_mib_handler * handler, netsnmp_handler_registration * reginfo, netsnmp_agent_request_info *
reqinfo, netsnmp_request_info * requests)
Implements the row_merge handler.
Definition at line 154 of file row_merge.c.
int netsnmp_row_merge_status_first (netsnmp_handler_registration * reginfo, netsnmp_agent_request_info * reqinfo)
Determine if this is the first row. returns 1 if this is the first row for this pass of the handler.
Definition at line 110 of file row_merge.c.
netsnmp_row_merge_status* netsnmp_row_merge_status_get (netsnmp_handler_registration * reginfo, netsnmp_agent_request_info * reqinfo, int
create_missing)
retrieve row_merge_status
Definition at line 67 of file row_merge.c.
int netsnmp_row_merge_status_last (netsnmp_handler_registration * reginfo, netsnmp_agent_request_info * reqinfo)
Determine if this is the last row. returns 1 if this is the last row for this pass of the handler.
Definition at line 130 of file row_merge.c.
Author
Generated automatically by Doxygen for net-snmp from the source code.
Version 5.4.3.pre1 23 May 2010 row_merge(3snmp)