Macro Scheduler and Windows Automation

Beginners :: RE: Extract Table / Extract Tag Examples and Understanding Need

Author: mtettmar
Posted: Fri Feb 03, 2012 9:31 am (GMT 0)
Topic Replies: 3

What you will need to do is use ExtractTable and then parse each value to spit out the "columns" by the br delimiters, or use ExtractTag with the HTML setting and parse each TD individually. Basically this table has ONE column with values separated by spaces using the BR tag. So you can parse it based on that. I would probably use ExtractTag or IEGetTags and then parse the extracted html with RegEx.
_________________
Regards,
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Please do not email/PM me for private support - post to the forum so that everyone benefits. For private support please send email via our web site.

Technical / Scripting :: RE: FileList RegEx Request

Author: jpuziano
Posted: Wed Feb 01, 2012 11:13 pm (GMT 0)
Topic Replies: 5

Or:

Let>pattern=(^|\x0D\x0A)(.[^\x0D\x0A]+?\.pdf)

\x0D\x0A being the hex representation of %CRLF%

And though this is a little cumbersome, its handy to know as you can represent any char, control char, etc. via its hex value.
_________________
jpuziano

Note: When posting code to the forum... please:
- highlight the code then click the "Code" button
- check the "Disable HTML in this post" checkbox
- check the "Disable Smilies in this post" checkbox

Technical / Scripting :: RE: FileList RegEx Request

Author: mtettmar
Posted: Wed Feb 01, 2012 11:05 pm (GMT 0)
Topic Replies: 5

Or:

Let>pattern=(^|\r\n)(.[^\r\n]+?\.pdf)

\r\n being perl regex style parlance for %CRLF%
_________________
Regards,
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Please do not email/PM me for private support - post to the forum so that everyone benefits. For private support please send email via our web site.

Technical / Scripting :: RE: FileList RegEx Request

Author: JRL
Posted: Wed Feb 01, 2012 6:49 pm (GMT 0)
Topic Replies: 5

I wrote:

what am I doing wrong?

I was informed off forum that the RegEx example provided assumes a semicolon as the line delimiter. Since I'm using "CRLF" as my delimiter I changed the "pattern" variable to:


Let>pattern=(^|%CRLF%)(.[^%CRLF%]+?\.pdf)

And the code now works perfectly.

Thank you Marcus. Greatly appreciated.
_________________
A few homemade utilities

Technical / Scripting :: RE: FileList RegEx Request

Author: JRL
Posted: Wed Feb 01, 2012 6:23 pm (GMT 0)
Topic Replies: 5

Thank you.
However, I'm not getting desired results, what am I doing wrong?

Here is a script that has a portion of a directory listing included. If you run the script two lists will display in a dialog. The list on the left is the original list. The list on the right is the RegExed list. The list on the right should include every line from the left hand list that is not a .pdf file name and not include any .pdf file names. I'm getting failures of both of these criteria.


Dialog>Dialog1

object Dialog1: TForm

  ClientHeight = 410

  ClientWidth = 715

  object MSMemo1: tMSMemo

    Left = 16

    Top = 20

    Width = 340

    Height = 380

    Text = ''

  end

  object MSMemo2: tMSMemo

    Left = 362

    Top = 20

    Width = 340

    Height = 380

    Text = ''

  end

end

EndDialog>Dialog1



LabelToVar>List,file_list



Let>pattern=(^|;)(.[^;]+?\.pdf)

RegEx>pattern,file_list,0,matches,nm,1,,new_file_list



SetDialogProperty>Dialog1,msmemo1,text,file_list

SetDialogProperty>Dialog1,msmemo2,text,new_file_list



Show>dialog1,



/*

List:

SU_LASER_JOHNLINK.txt

SU_Laser_JOHNLINK.JPG

SU_Laser_JOHNLINK.avi

JOHNLINK_SU_MetalFinishing.pdf

JOHNLINK_SU_MetalFinishing.JPG

JOHNLINK_SU_Laser.pdf

JOHNLINK_SU_Forming.avi

JOHNLINK_RFQ.pdf

JOHNLINK_Rev_Checklist_Scan.pdf

*/

_________________
A few homemade utilities

Technical / Scripting :: RE: FileList RegEx Request

Author: mtettmar
Posted: Wed Feb 01, 2012 4:55 pm (GMT 0)
Topic Replies: 5

Here you go:

Let>spec=C:\Users\User\Documents\*.*

GetFileList>spec,file_list

Let>pattern=(^|;)(.[^;]+?\.pdf)

RegEx>pattern,file_list,0,matches,nm,1,,new_file_list

If you're new to RegEx I recommend buying a copy of RefexBuddy.

Paste the file list and the regex pattern into RegexBuddy and it will show you the matches and explain the expression.
_________________
Regards,
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Please do not email/PM me for private support - post to the forum so that everyone benefits. For private support please send email via our web site.

Technical / Scripting :: FileList RegEx Request

Author: JRL
Subject: FileList RegEx Request
Posted: Wed Feb 01, 2012 3:59 pm (GMT 0)
Topic Replies: 5

One of these days I'm going to have to knuckle down and learn RegEx. Problem is I don't do enough text manipulation to remember what I did last time I looked at it. So I'm hoping someone can help me with this.

I'm doing a GetFileList> and producing a CRLF delimited list of all files in a folder. I would like to run that list through RegEx and produce a list that does not include any PDF files. I want to see all of the other files of any type but not any files with a .PDF extension.

Is this possible? Can someone provide the RegEx line to do this?

Thank you
Dick
_________________
A few homemade utilities

Technical / Scripting :: RE: push key, then click somewhere on the screen

Author: JRL
Posted: Wed Feb 01, 2012 2:59 pm (GMT 0)
Topic Replies: 1

Here's one way

I remarked out the click part to prevent issues if someone were to copy and run this as-is.


Dialog>Dialog1

object Dialog1: TForm

  Caption = 'Click Screen'

  ClientHeight = 65

  ClientWidth = 439

  object MSButton1: tMSButton

    Left = 12

    Top = 20

    Width = 75

    Height = 25

    Caption = 'Click 1'

  end

  object MSButton2: tMSButton

    Left = 96

    Top = 20

    Width = 75

    Height = 25

    Caption = 'Click 2'

  end

  object MSButton3: tMSButton

    Left = 180

    Top = 20

    Width = 75

    Height = 25

    Caption = 'Click 3'

  end

  object MSButton4: tMSButton

    Left = 264

    Top = 20

    Width = 75

    Height = 25

    Caption = 'Click 4'

  end

  object MSButton5: tMSButton

    Left = 348

    Top = 20

    Width = 75

    Height = 25

    Caption = 'Click 5'

  end

end

EndDialog>Dialog1



AddDialogHandler>Dialog1,MSButton1,OnClick,Click(100,100)

AddDialogHandler>Dialog1,MSButton2,OnClick,Click(200,200)

AddDialogHandler>Dialog1,MSButton3,OnClick,Click(300,300)

AddDialogHandler>Dialog1,MSButton4,OnClick,Click(400,400)

AddDialogHandler>Dialog1,MSButton5,OnClick,Click(500,500)



Show>Dialog1,



SRT>Click

  GetCursorPos>CurX,CurY

  MouseMove>Click_var_1,Click_var_2

  //LClick

  //MouseMove>CurX,CurY

END>Click

_________________
A few homemade utilities

General Discussion :: RE: personal.xls

Author: snapper1969
Posted: Wed Feb 01, 2012 12:14 pm (GMT 0)
Topic Replies: 4

mtettmar wrote:

Having spent some time googling this I don't think personal.xls is opened by default when Excel is instantiated as COM object. Try opening personal.xls as well, e.g.:

VBRun>OpenAndRun,C:\Users\User\AppData\Roaming\Microsoft\Excel\XLSTART\personal.xlsb,TestMacro

But I guess you might actually need to modify the VBScript function to open both personal.xlsb and your test.xls doc if you are wanting to affect something inside test.xls

It might be easier to move the macro to test.xls. Or you could recode it in VBScript and run directly inside Macro Scheduler.

Thanks Marcus,

I think I'll probably try and recode it in VBScript, better than opening another spreadsheet.

John

General Discussion :: RE: personal.xls

Author: mtettmar
Posted: Wed Feb 01, 2012 11:12 am (GMT 0)
Topic Replies: 4

Having spent some time googling this I don't think personal.xls is opened by default when Excel is instantiated as COM object. Try opening personal.xls as well, e.g.:

VBRun>OpenAndRun,C:\Users\User\AppData\Roaming\Microsoft\Excel\XLSTART\personal.xlsb,TestMacro

But I guess you might actually need to modify the VBScript function to open both personal.xlsb and your test.xls doc if you are wanting to affect something inside test.xls

It might be easier to move the macro to test.xls. Or you could recode it in VBScript and run directly inside Macro Scheduler.
_________________
Regards,
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Please do not email/PM me for private support - post to the forum so that everyone benefits. For private support please send email via our web site.

Technical / Scripting :: push key, then click somewhere on the screen

Author: MikeTB78
Subject: push key, then click somewhere on the screen
Posted: Wed Feb 01, 2012 9:59 am (GMT 0)
Topic Replies: 1

hi,

I want to make a macro when i click "1", my mouse click somewhere on my screen.
When i click "2", it clicks somewhere else and so on.

thx Mike

Technical / Scripting :: RE: 3x Variables From One Path

Author: CyberCitizen
Posted: Wed Feb 01, 2012 9:32 am (GMT 0)
Topic Replies: 5

Sorry YouTube butchered the quality of the video, I will have to re-upload it.
_________________
THE FIREFIGHTER

Technical / Scripting :: RE: 3x Variables From One Path

Author: jpuziano
Posted: Wed Feb 01, 2012 9:17 am (GMT 0)
Topic Replies: 5

Hi CyberCitizen,

Here's all three along the lines of what I had begun above:


Let>path=C:\Documents and Settings\ALL USERS\Desktop\Desktop Slider v1.03\Desktop Slider\desktop slider.exe



//Variable1

Let>matches_1=

Let>pattern=^.*\\(?=[^\\]*\\[^\\]*)

RegEx>pattern,path,0,matches,num,0

MDL>matches_1



//Variable2

Let>matches_1=

Let>pattern=^.*\\([^\\]*)\\[^\\]*$

RegEx>pattern,path,0,matches,num,1,$1,Variable2

MDL>Variable2



//Variable3

Let>matches_1=

Let>pattern=(?<=\\)[^\\]*$

RegEx>pattern,path,0,matches,num,0

MDL>matches_1

And then I thought, there's an easier way... just use grouping... see below:


Let>path=C:\Documents and Settings\ALL USERS\Desktop\Desktop Slider v1.03\Desktop Slider\desktop slider.exe



Let>pattern=^(.*\\)([^\\]*)\\([^\\]*)$

RegEx>pattern,path,0,matches,num,1,$1,Variable1

RegEx>pattern,path,0,matches,num,1,$2,Variable2

RegEx>pattern,path,0,matches,num,1,$3,Variable3

MDL>Variable1

MDL>Variable2

MDL>Variable3

Hope someone finds this helpful... take care.
_________________
jpuziano

Note: When posting code to the forum... please:
- highlight the code then click the "Code" button
- check the "Disable HTML in this post" checkbox
- check the "Disable Smilies in this post" checkbox

Technical / Scripting :: RE: 3x Variables From One Path

Author: CyberCitizen
Posted: Wed Feb 01, 2012 8:48 am (GMT 0)
Topic Replies: 5

Thanks for the help guys. I got what I was after. I ended up using Pepsi's code, changed it alittle but it works that was the main thing.

This was more just a tool for me, but others might find it useful so here you go.

YouTube: Folder Icon Changer
_________________
THE FIREFIGHTER

Enhancement Suggestions :: Extracting Sourcecode

Author: rullbandspelare
Subject: Extracting Sourcecode
Posted: Wed Feb 01, 2012 7:34 am (GMT 0)
Topic Replies: 0

I would like to have the option to include the script text in the compiled exectable so that I can extract it by passing switch and a password to the compiled exe.
This would realy help me!

Thanks!