Re^4: search pattern with digits

thanks for the responses...

lemme make it clear ... the argument(s) which are given is jus the phrase. for example
total rejected rows

or
rejected number of rows

in the log file which im gonna parse it with the script contains:

log.txt

total rejected rows: 1000
total rejected rows:    1254
total rejected rows: 1000
total rejected rows:    1254
total rejected rows: 1000
3000 rejected number of rows
8700 rejected number of rows
65000 rejected number of rows
1200 rejected number of rows
4300 rejected number of rows
total rejected rows:    1254
total rejected rows: 1000
total rejected rows:    1254
total rejected rows: 1000
total rejected rows:    1254
54000 rejected number of rows
4000 rejected number of rows
[download]

the programs works only for "total rejected rows:", ie., if the number (desired result) is at the end of the search phrase, but if it is at the beginning for example, "rejected number of rows" the number present at the beginning is not returned... but always the search phrase has the digits either at the beginning or at the end... if u have more questions plz lemme kno...

thanks.

Comment on Re^4: search pattern with digits Download Code

Replies are listed 'Best First'.
Re^5: search pattern with digits by hipowls (Curate) on Feb 14, 2008 at 22:22 UTC
How is the search string given? What search string is given? How the input data vary? How will what you search for depend on the input data? Will you always be capturing the same data? For the example you have given where you always want to capture a number after or before "rows rejected" `qr{(?\| \Q$string\E [^\d]* (\d+) \| (\d+) [^\d]* \Q$string\E ) }x` [download] will capture the last number before a given search string or if there isn't one the first number after the string. Note given `records processed 23456, total rows rejected 567` [download] it will match 23456. What is the input when one row is rejected? Is it `1 rows rejected` [download] or `1 row rejected` [download] Know your data;)	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^5: search pattern with digits
by hipowls (Curate) on Feb 14, 2008 at 22:22 UTC

How is the search string given?
What search string is given?
How the input data vary?
How will what you search for depend on the input data?
Will you always be capturing the same data?

For the example you have given where you always want to capture a number after or before "rows rejected"

qr{(?|
    \Q$string\E [^\d]* (\d+)
|
    (\d+) [^\d]* \Q$string\E
)
}x
[download]

records processed 23456, total rows rejected 567
[download]

What is the input when one row is rejected? Is it

1 rows rejected
[download]

1 row rejected
[download]

[reply]
[d/l]
[select]