WTF? Do I completely misunderstand how Regex.Replace works, or what?
This is the code after I unrolled everything:
var code = indented;
for (var index = 0; index < _strings.Count; index++)
{
var item = _strings[index];
Debug.WriteLine($"Replacement {index}:");
var pattern = $"{StringPlaceholder}{{{item.Length}}}";
Debug.WriteLine($"item: {item}");
Debug.WriteLine($"pattern: {pattern}");
Debug.WriteLine($"code: {code}");
var replacer = new Regex($"{StringPlaceholder}{{{item.Length}}}", RegexOptions.CultureInvariant);
code = replacer.Replace(code, item, 1);
This is the output:
Replacement 0: item: "SELECT `Sequence ID` as Header1, '' as Header2 , Sum(`No Of Try`) AS Header3, '' as Header4 ,'' as Header5 ,'' as Header6 ,'' as Header7 ,'' as Header8 ,'' as Header9 ,'' as Header10 FROM `'" pattern: X{192} code: ctxt = XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX & sheetName & XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX & KitNo & XXXX
The second replacement is only replacing 61 characters of the 65 character match.
@MathieuGuindon Apologies for late commentary on the shared Battleship workbook. It currently errors on workbook open on line: TitleSheet.Activate with Run-Time error 1004. Was this intended? I can comment the line out but am wondering if I am missing a trick here?
Shapes can be used to make some very elegant message boxes. But unlike the built-in MsgBox() they do not return a result. This makes it very difficult to manage the program flow. Instead of waiting on an inline response, you have to show the Shape Message, have it trigger a Macro and then conti...
Hello... I had two queries : (1) How to include a javascript code in an HTML file while I'm writing on notepad? (2) How to write a code such that I accept some answers through HTML code and give some output based on answer?
@MathieuGuindon I am telling that in (2) , I will use option tag and ask user some questions... Based on their answers, the webpage would reply differently at different answers... Can I do that using JS...?
So last night I realized I was being boneheaded about my trace implementation and tweaked it. Does anyone else think this looks more useful?
the upper sheet is a snapshot of the current contents of the COM safe; the lower sheet is a trace of all activity made in the COM safe, including the stack trace so we can see we've been leaking windows created from the RegisterWindowHooks.... right?
@MathieuGuindon Unsure. Now it says An error occurred while loading 'ThisWorkbook'. Do you want to continue loading the project? Then a series of other messages. So guess it didn't like the original opening.
Do you mind terribly sending another copy if you have one to hand? I am looking forward to going through it properly.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4433?src=pr&el=h1) Report > Merging [#4433](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4433?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/f38ebf776c9de99883f2e3aca5e2291f0569bded?src=pr&el=desc) will **increase** coverage by `<.01%`. > The diff coverage is `100%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4433?src=pr&el=h1) Report > Merging [#4433](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4433?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/f38ebf776c9de99883f2e3aca5e2291f0569bded?src=pr&el=desc) will **increase** coverage by `<.01%`. > The diff coverage is `100%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4383?src=pr&el=h1) Report > Merging [#4383](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4383?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/f38ebf776c9de99883f2e3aca5e2291f0569bded?src=pr&el=desc) will **decrease** coverage by `3.07%`. > The diff coverage is `n/a`.
What a world we live in. Even playground sand has to be listed as carcinogen because of the silica. SMH. #Newsflash #LifeCausesCancer it's the leading cause of it actually.
Shapes can be used to make some very elegant message boxes. But unlike the built-in MsgBox() they do not return a result. This makes it very difficult to manage the program flow. Instead of waiting on an inline response, you have to show the Shape Message, have it trigger a Macro and then conti...
VBA Rubberducking
VBA Rubberducking