[Richard Crist]

\r\n

\r\n \r\n

\r\n

Quote:

\r\n \r\n \r\n \r\n \r\n

\r\n \r\n

\r\n Originally Posted by Richard Crist\r\n \r\n

\r\n

1) You would like to find only rows with two 6-digit numbers?
\r\n2) And then pull out those two 6-digit numbers for use later?
\r\n3) So only row 2 above is a good row, and from that row you want the numbers 123456 and 777777 for use later?

\r\n \r\n

\r\n

Since the poster hasn\'t replied and this thread seems popular, I shall post the answer.
\r\n
\r\n\\D*(\\d{6})\\D+(\\d{6})\\D*
\r\n
\r\nThis says find:
\r\nzero or more non-digit characters
\r\nfollowed by a 6 digit number
\r\nfollowed by 1 or more non-digit characters
\r\nfollowed by zero or more non-digit characters
\r\n
\r\nThe numbers you want will be in groups 1 and 2, represented by the first and second parentheses.
\r\n
\r\nInformation can be found here.\r\n

\r\n

[Richard Crist]

hi,

I've a problem with a regular expression..
I'll use it, to..
match a bank account line, so accept the complete line
and filter two 6-digit-numbers out of the string to put it in reference 1 and 2
(or only one, thats the problem)
(for later use with coldfusions REreplace function ..
:select all text and replace it with the numbers, found in the text, separated by kommas )

heres the regEx:
^(?:.*?)(\d{6,6})(?:-\d{2,2}|)(?:.*?)(?:(\d{6,6})(?:-\d{2,2}|))?

now, you can see the problem in the result of example 2 (using regexTester).
where is the second number,
the regex doesnt find it, but why does it succed in searching in example 3?

thank you

example rows:
1: hans meier rechnung nr.04-123456-04 fa any
2: hans meier rechnung nr.04-123456 777777-04 fa any
3: hans meier rechnung nr.04-123456777777-04 fa any

results:
1: ok, data in ref. 1
2: not ok (data in ref.1 ok, but 2 is empty)
3: ok data in ref. 1+2 (removed whitespace between the numbers)

[federente]

hi,

I've a problem with a regular expression..
I'll use it, to..
match a bank account line, so accept the complete line
and filter two 6-digit-numbers out of the string to put it in reference 1 and 2
(or only one, thats the problem)
(for later use with coldfusions REreplace function ..
:select all text and replace it with the numbers, found in the text, separated by kommas )

heres the regEx:
^(?:.*?)(\d{6,6})(?:-\d{2,2}|)(?:.*?)(?:(\d{6,6})(?:-\d{2,2}|))?

now, you can see the problem in the result of example 2 (using regexTester).
where is the second number,
the regex doesnt find it, but why does it succed in searching in example 3?

thank you

example rows:
1: hans meier rechnung nr.04-123456-04 fa any
2: hans meier rechnung nr.04-123456 777777-04 fa any
3: hans meier rechnung nr.04-123456777777-04 fa any

results:
1: ok, data in ref. 1
2: not ok (data in ref.1 ok, but 2 is empty)
3: ok data in ref. 1+2 (removed whitespace between the numbers)