SSMS regex question: I've clicked the "square-star" button to use RegEx, I've entered NULL,'\n in the search box, but it's not finding it. I've got hundreds of lines that end in this text. I've tried highlighting and copy/paste into the search box, but it's not finding the newline. What am I missing?
It tells me: "The following specified text was not found: NULL,'\n"
MS Docs says that \n is a new line. It also indicates that $ anchors the search to the EOL. Neither seems to be able to find anything at the end of the line.
If I type in NULL,', I get hundreds of highlighted results as soon as I add $ or \n all the highlights go away.
I've toggled Alt-e (RegEx) on an off multiple times.
#justgottabedifficult :(
Is it because this is shown in the Reference List section
and this is shown in the Find What section?
How does it know which usage to apply?
RegEx itself is working, I was able to find: \t and replace with ',' just fine.
So happy the website no longer needs Rubberduck.dll to list inspections and update the reported latest build version! The /build/version controller method uses the tag names to parse the version number, so as long as our tags look like "v0.0.0[.0]", everything should "just work" =)
@FreeMan save the .sql file and edit it in Notepad++?
My code works fine when I've written it last week and this week when I got new file and run my code, it didn't work to copy paste to another sheet.
Can someone helps me please?
Option Explicit
Sub Import_ClientRating()
'1. First Import data 1-to-1 to Table template
'2. Used Find function to ...
yeah, might have to do that... I discovered that \nwill find the EOL. That's all I really need... I replaced it with '),\n and got everything double spaced! I'd have thought that S&R would work the same as it normally does - "Find this replace with that", but not, apparently with newline.
N++ found \n, but replacing it with '),\n gave me \n'),
?????
That was using N++'s "Extended" search mode. Using "Regular Expression" mode doesn't improve things.
@FreeMan Find can only find text inside a single line. If you want to find something spanning multiple lines, you need Find in file or whatever it is called.
Hi folks :-) I see you've updated inspections on website. Good job :-)
One little thing about inspections though. Few days ago I wanted to disable all inspections within my TestModule.
From what I found on the Wiki, I had to do multiple @IgnoreInspection ThisInspectionName (or something like that) on each line within that module.
And the 'ThisInspectionname' I found from Inspection window - look on the name - fire up the site - ctrl + f that name - that returns the inspection short name and that I added to the line.
Is there an existing proposition to add Inspection shortnames to the RD Inspection Results window?
MS Docs says that \n is a new line. It also indicates that $ anchors the search to the EOL. Neither seems to be able to find anything at the end of the line.
What attribute should I use for my added class that's encapsulating the column indices? public ToDoExplorerColumnHeadingsOrder ColumnHeaderIndices { get; }
> **Justification** The `VersionCheck` feature is currently sending an asynchronous HTTP request to http://www.rubberduckvba.com/build/version/stable, which responds with the version number for the latest "green release".
With the website's recent update, that version number is now coming straight from [releases](https://github.com/rubberduck-vba/Rubberduck/releases), through the GitHub API - rather than returning the assembly version of the Rubberduck.dll assembly depoyed to the website, it
wee. I love it when they play hide'n'seek with their features.
I was working on automating an external program and looked in 100 different places trying to find out how to open a search dialog. Even mashed some common keyboard shortcuts. Asked and was told, "just start typing the number and dialog will pop up automatically."
its just too much money to update it to a version that can run on in support database software
sadly
anywho this disgusting mass of nested queries stopped working
and its throwing a wierd error
so, the two base queries to this query work, pull up data etc.
SELECT qry_Operation_20_good.BASE_ID
,qry_Operation_20_good.PART_ID
,qry_Operation_20_good.OPERATION_SEQ_NO
,Sum([SumOfGOOD_QTY] - [QTY40]) AS Waiting_For_Glass
FROM qry_Operation_20_good
INNER JOIN qry_Operation_40_total ON qry_Operation_20_good.BASE_ID = qry_Operation_40_total.BASE_ID
GROUP BY qry_Operation_20_good.BASE_ID
,qry_Operation_20_good.PART_ID
,qry_Operation_20_good.OPERATION_SEQ_NO
HAVING (((Sum([SumOfGOOD_QTY] - [QTY40])) > 100));
BUT i get an invalid operation error when it hits this part
which causes queries that use this mess to silently crash to restart access
@FreeMan it's on a main menu of some sort, so no data to enter; but you have to be typing into "nowhere", not into one of various filtering textboxes.....
because it's a thing everyone does, typing stuff into any random non-text controls, right?
welp, an engineer started monkeying around with some of the queries, and linked in some other random query and suddenly the queries stopped crappin themselves
> The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.
no, there are about 26 columns. I had oh... 2500 ish rows.
fortunately, I really didn't need them all, only the newest couple of hundred made it into the final table. That was just the load to the temp table.
I just peeled the oldest stuff off until I was under the threshold
and, to answer my own question, no, this isn't the problem. At this point, my first file loaded has 400 rows of data, the 2nd has 300 rows. Since they're each loaded individually, that's not causing it to puke.
though, when it gets to this big'un (my bad, 3200 rows), it might struggle, but it loaded it last month on the old server with roughly 2700 rows
finishing up the manual loads, then the reports, then chucking this baby with the bath water & finding a new plan
> **Rubberduck version information** Version 2.4.1.4719 OS: Microsoft Windows NT 10.0.17763.0, x64 Host Product: Microsoft Office x64 Host Version: 16.0.11629.20136 Host Executable: WINWORD.EXE
**Description** As per the title. I have a number of Modules and classes with the '@IgnoreModule annotation. Where the Module is a '@TestModule, it is hidden from code inspections. Where '@IgnoreModule is in a normal Class or Module the respective Class or Module is not ignored for code in
> Version 2.4.1.24543 OS: Microsoft Windows NT 6.1.7601 Service Pack 1, x64 Host Product: Microsoft Office 2013 x86 Host Version: 15.0.5023.1000 Host Executable: EXCEL.EXE
**Description** Export option for settings window doesn't export settings.
**To Reproduce** Steps to reproduce the behavior: 1. Display settings window from IDE Rubberduck>Settings 2. Click on `Export` in top right of window to choose directory and filename 3. Navigate to directory and there is no file
@MathieuGuindon very nice job on the inspection docs. Is there any value in reusing some of that for in-app docs? not everyone has permanent internet access...
public class ToDoExplorerColumnHeadingsOrder
{
public int DescriptionColumnIndex { get; set; }
public int ProjectColumnIndex { get; set; }
public int ModuleColumnIndex { get; set; }
public int LineNumberColumnIndex { get; set; }
public ToDoExplorerColumnHeadingsOrder(int descriptionColumnIndex = 0, int projectColumnIndex = 1, int moduleColumnIndex = 2, int lineNumberColumnIndex = 3)
{
DescriptionColumnIndex = descriptionColumnIndex;
ProjectColumnIndex = projectColumnIndex;
so you're looking at <GridColumnOrdering><DescriptionColumnIndex>0</DescriptionColumnIndex><ProjectColumnIndex>1</ProjectColumnIndex><.../></GridColumnOrdering>
public ToDoExplorerColumnHeadingsOrder(int descriptionColumnIndex = 0, int projectColumnIndex = 1, int moduleColumnIndex = 2, int lineNumberColumnIndex = 3) then needs to be removed?
My code works fine when I've written it last week and this week when I got new file and run my code, it didn't work to copy paste to another sheet.
Can someone helps me please?
Option Explicit
Sub Import_ClientRating()
'1. First Import data 1-to-1 to Table template
'2. Used Find function to ...
VBA Rubberducking
VBA Rubberducking