JRL wrote: ↑

Sun Feb 02, 2020 6:25 am

Code: Select all

ExtractFileName>command_line,startedBy
MDL>startedBy

That one didn't work because of the quotes. So a RegEx is first needed.

Yes, much better! Thanks

Ah, smart check. Thanks for that.

I was wondering if the comments are stripped out of the script if I compile them? If not, then I should not comment that much since if I have a huge loop (many iterations) the comments would be parsed over and over again for no reason.

And as a follow up on this, I would be really happy to have a %SCRIPT_DIR_PARENT% (similar to ../ in other coding languages). See this code snippet for the "why" :) Let>REGEX_PATTERN=(?<=").*?(?=") RegEx>REGEX_PATTERN,COMMAND_LINE,0,SCRIPT_DIR_CMD,,,, Separate>SCRIPT_DIR_CMD_1,\,SCRIPT_DIR_CMD Let>R...

I find myself using this over and over again just to see if the script is running as compiled or in developer mode (as I like to think about it). I would be really happy if we could just look at a variable to tell if it's running as compiled or script (through the editor). Let>REGEX_PATTERN=(?<=").*...

nodochau wrote: ↑

Wed Jan 22, 2020 2:55 pm

Hi Dorian,
In my sample as I mentioned above, there are 3 cols and but why arrayname_row_count returns 4. It should return 3, right?

What you see and how the XLS looks like are two different things. There's probably some syntax in the fourth row. I could be simply that you clicked on a cell....

In the dialog editor you can specify what buttons should be visible.

RTFM

Thanks for the feedback!

Instead of IE[0] you may want to create a unique integer for each sub routine. So that would be IE[%k%] or perhaps in your instance IE[%SUBNAME_Var_1%].

Yep, you're spot on.

Nice and clever! Should be possible by default in my book but this will do until then. Thanks for sharing.

I would use Image Magick, script using cli to analyze the image. When you have a jump in the colors used you have a bot warning.

You should use the a specific regex "flavor"... Can't remember the exact name right now though.