Regex to identify rows that do not contain exact number of occurences of quotemark character using Notepad++

Posted by SamAspin on Stack Overflow See other posts from Stack Overflow or by SamAspin
Published on 2012-10-04T16:55:59Z Indexed on 2012/10/05 9:37 UTC
Read the original article Hit count: 335

Filed under:

regex

|

notepad++

I would like to be able to jump to rows that dont contain 6 quotemarks in a quoted-CSV file as it feels like a good way to identify broken rows.

I think using a regular expression with Notepad++'s find features would be a sensible approach but I'm not sure how to pick the rows up.

6 quotemarks (") would suggest a complete row so I want to skip to any row that does not contain 6.

Here is some sample data to play with, in this example its the 4th line I'd like to jump to

"sam","mark","dave"
"sam","mark","dave"
"sam","mark","dave"
"sam","mark","
dave"
"sam","mark","dave"
"sam","mark","dave"

© Stack Overflow or respective owner

Related posts about regex

Find multiple regex in each line and skip result if one of the regex doesn't match

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a list of variables: variables = ['VariableA', 'VariableB','VariableC'] which I'm going to search for, line by line ifile = open("temp.txt",'r') d = {} match = zeros(len(variables)) for line in ifile: emptyCells=0 for i in range(len(variables)): regex = r'('+variables[i]+r')[:|=|\(](-… >>> More
OWASP Regex Repository: Is this regex correct?

as seen on Stack Overflow - Search for 'Stack Overflow'
I was looking at the regular expression for validating various data types from the (OWASP Regex Repository). One of the regular expressions in there is called safetext and looks like: ^[a-zA-Z0-9\s.\-]+$ My first question is: Is this regular expression correct? complementary question If this… >>> More
Make a Perl-style regex interpreter behave like a basic or extended regex interpreter

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing a tool to help students learn regular expressions. I will probably be writing it in Java. The idea is this: the student types in a regular expression and the tool shows which parts of a text will get matched by the regex. Simple enough. But I want to support several different regex… >>> More
JS regex isn't matching, even thought it works with a regex tester

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a piece of client-side javascript code that takes a function and finds the derivative of it, however, the regex that's supposed to match with the power rule fails to work in the context of the javascript program, even though it sucessfully matches when it's used with an independent regex… >>> More
c# RegEx with "|"

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to be able to check for a pattern with | in them. For example an expression like d*|*t should return true for a string like "dtest|test". I'm no regex hero so I just tried a couple of things, like: Regex Pattern = new Regex("s*\|*d"); //unable to build because of single backslash Regex Pattern… >>> More

Related posts about notepad++

How to make Notepad++ take over from the standard notepad.exe

as seen on Super User - Search for 'Super User'
I could do this easily with TextPad, then I got irritated with Textpad once I'd played with Notepad++. Now that I've removed Textpad: I want Notepad++ to take over the right-click Edit option in Explorer, and I want Notepad++ to come up when I type notepad in the command prompt. I know that… >>> More
Open text file in notepad/notepad++ based on size

as seen on Super User - Search for 'Super User'
Hi, When i double click a text document, if that text file is more than 1MB(or some specified size) I want that text file to be opened in Notepad++ while the files that are smaller should be opened in notepad itself. Is there any way i can achieve this.? Thanks >>> More
Notepad++ doesn't launch (notepad++.exe present in the task manager)

as seen on Super User - Search for 'Super User'
Yesterday Notepad++ was runnable, but today it doesn't. In spite of the notepad++.exe (with its 13 process) presence is the tasks manager, Notepad++ window doesn't launch. I tried to uninstall and re-install the sofware (and the first launch works), notepad.exe is present in C:\Windows and C:\Windows\Sytem32… >>> More
EOL in Notepad++ and Notepad

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Notepad++ to create some text file, but I noticed when the generated file is opened in Windows Notepad, the file contents get mal-formated due to the fact that Notepad++ use LF and EOL character, while Notepad expects CR + LF. Is there any way to change this behavior in Notepad++?? >>> More
Useful utilities - PFE, Notepad++ and XML Notepad 2007

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
All three editors are free to download and use! PFE http://www.lancs.ac.uk/staff/steveb/cpaap/pfe XML Notepad 2007 http://www.microsoft.com/downloads/details.aspx?familyid=72d6aa49-787d-4118-ba5f-4f30fe913628&displaylang=en Notepad++ http://notepad-plus.sourceforge.net/uk/download… >>> More