List Info

Thread: finding all newlines NOT followed by 5 numbers and a comma




finding all newlines NOT followed by 5 numbers and a comma
user name
2006-03-15 22:28:25
I am looking for a regular expression to remove any newline
character
that is not followed by 5 numbers and a comma.

Here is what I currently use, but if my dataset were to
contain the
example below (which it might someday) then this expression
won't work.

Find: \n\([^0-9]\)
Replace: \1

This currently finds a newline followed by any non-numerical
character

What will work?

Example CSV Data File:

10398,400000,"Bookmark.................
10398,400000,"Poster.................

1<P>Measures

<1P>1v
17 x 23"". Non-laminated."
sdfsdf
10399,400000,"Reading Certificate.............

Thanks for your help!

- JS


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Regex" group.
To post to this group, send email to regexgooglegroups.com
To unsubscribe from this group, send email to
regex-unsubscribegooglegroups.com
For more options, visit this group at http://groups.go
ogle.com/group/regex
-~----------~----~----~----~------~----~------~--~---

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )