Test is successful but Search doesn't find anything

[mb96851]

This is my first time using Rummage. In Sublime Text my Find in Files regex searches 77 files and finds 261 matches across 5 files. In Rummage it searches the same 77 files, skips 0, but doesn't find any matches. If I use the Regex Tester and copy the contents of one of my files into it, the tester finds the same matches that Sublime Text does.

I have three things checked in Text search options: Search with regex, Create backups, Force ASCII

This is my regex:
"[ &]*_\n[ &]*"( *(?:INSERT|DELETE|UPDATE|SET|SELECT|INTO|FROM|WHERE|AND|OR|GROUP BY|HAVING|ORDER BY|\( |.*;"|, ))

I'm trying to clean up, and fix, SQL text strings in a project to all have the same format and I intend to do this in all branches of my code repository to reduce the chance future merges will break things. The above regex is step 1 of 50+ steps, so I'm really hoping I can get Rummage Search Chains to work.

Anyone have any suggestions?

[facelessuser]

Please provide a minimal file that we can test. I need a concrete, reproducible example or I cannot begin to guess what you are doing wrong. It is possible that you have your glob pattern configured wrong or any number of issues, but without a reproducible example, I cannot help.

[facelessuser]

Now that I mention glob patterns, please take a screenshot showing your file pattern settings, etc. as well.

[facelessuser]

I was able to take your regex and construct an example in the regex tester that worked:

Then I placed the passing example in a file and Rummage found it no problem:

So, I will definitely need more information. I suspect your issue is a user error not a Rummage error, but without knowing exactly what you are doing, I cannot offer further guidance.

[mb96851]

Yes, hopefully it's just user error. :)

Here is an Example.bas.txt with one of the routines that needs fixing.
(Github wouldn't let me add Example.bas. Since it is actually at text file, I changed the extension to .txt.)

I pasted the contents of the example into Tester and it finds everything.

Here is what the search tab looks like before clicking Search.

And my no results.

This is the folder I'm trying to search. Everything in the folder, except for the Microsoft Access stub, is a text file.

I think i also tweaked the Search Preferences before hand. Here is what they look like.

[facelessuser]

Just to be clear, the directory you are showing me in Windows file explorer does not match the path in rummage, you noticed this right?

[mb96851]

Yeah always good to double & triple check. I have three clones updated to 3 different branches. I'm actually hoping to make these changes to all of them at the same time.

[facelessuser]

One more question, are there symlinks involved? Or whatever the windows equivalent is called.

[facelessuser]

@mb96851 Also, can you tell me what line endings the file uses? You can enable "show_line_endings": true, in Sublime and it will show you the line endings in the status bar. Or go to view -> line endings and tell what is checked. If it is Windows, then \n is probably not going to cut it. Sublime will normalize line endings in the editor view, but when searching the raw file, windows line mode will use \r\n. Let me know your findings before I continue any further.

[facelessuser]

@mb96851 Yeah, the file you gave me had Windows new lines. Since you have backrefs enabled, just use \R which will file line endings of \n, \r, or \r\n. Either that or use explicit \r\n. Once I updated the pattern to use \R instead or \n, it all worked fine.

[mb96851]

Thanks for figuring it out!