Community

Posted: **Thu May 17, 2007 6:03 pm**

My CSV file contains lines like these..

"A","234234","7UM*","2345","00070","12343","120 DEL J.NORRIS"
"B","23423","8UM*","2345","00070","12343","120 DEL J.IMTIH"
"V","1234","6UM*","2345","00070","12343","ABCDEFG"
"V","1234","6UM*","2345","00070","12343",""

I want to find rows where last column (eg. "120 DEL J.NORRIS") contains any numeric values i.e. 1st and 2nd row but not 3rd and 4th row

Is this possible via RegEx?

Thank you very much

Posted: **Thu May 17, 2007 8:38 pm**

This matches the distinctive parts of the lines you're interested in:
[0-9][^"]*"$

This matches the entire lines you're interested in:
^.*[0-9][^"]*"$

Posted: **Thu May 24, 2007 7:23 pm**

Thank you very much! that did the trick! now I have to figure out how it really works ; )

Posted: **Sun May 27, 2007 11:35 am**

[0-9][^"]*"$ matches

Code: Select all

1.    [0-9]         any digit

2.    [^"]*         a string not containing double quotes, that is:
2.1     [^"]          any character except double quote
2.2     *             repeated any number (possibly zero) of times

3.    "             a double quote

4.    $             the end of a line

The $ anchors the match to the end of the line. So the regex matches if a line contains a digit and ends with a " , and there is no intervening " between that digit and that final ". The regex matches everything from the digit to the end of the line (but not the newline itself).

^.*[0-9][^"]*"$ matches

Code: Select all

1.    ^             the beginning of a line

2     .*            any string within a line, that is:
2.1     .             any character except newline
2.2     *             repeated any number (possibly zero) of times

3.    [0-9][^"]*"$  as above

So this regex matches any whole line containing what the first regex matches.

Community

Help with RegEx and csv file

Help with RegEx and csv file