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 regex googlegroups.com
To unsubscribe from this group, send email to
regex-unsubscribe googlegroups.com
For more options, visit this group at http://groups.go
ogle.com/group/regex
-~----------~----~----~----~------~----~------~--~---
|