Search found 1382 matches

by Dorian (MJT support)
Wed Nov 20, 2024 10:17 pm
Forum: Technical / Scripting
Topic: Send file (PDF) to printer
Replies: 1
Views: 124

Re: Send file (PDF) to printer

My research suggests you can do this with Powershell, and for this solution you need Acrobat Reader to be installed. I tested this and it successfully printed to my default printer. Let>PDFFile=D:\MJT\IN\10036659565.pdf LabelToVar>pscode7,ps let>RP_WINDOWMODE=0 Run>powershell.exe %ps% /* pscode7: St...
by Dorian (MJT support)
Wed Nov 20, 2024 4:23 pm
Forum: Beginners
Topic: Sending variables
Replies: 3
Views: 105

Re: Sending variables

Always happy to help.
by Dorian (MJT support)
Wed Nov 20, 2024 11:43 am
Forum: Technical / Scripting
Topic: Issue with Multiple While Commands?
Replies: 2
Views: 117

Re: Issue with Multiple While Commands?

My first thought is to turn on logging and then carefully investigate the logfile. You should be able to see exactly how the script runs and what's going awry. Pay close attention to unexpected variables. It can be painstaking but being able to "look under the hood" in that way is invaluable.
by Dorian (MJT support)
Tue Nov 19, 2024 10:42 pm
Forum: Beginners
Topic: Sending variables
Replies: 3
Views: 105

Re: Sending variables

It's the spaces. Try this :

Code: Select all

Let>fn=I:\Report\AReports\ClientAR%nwdt%
by Dorian (MJT support)
Tue Nov 12, 2024 4:23 pm
Forum: Technical / Scripting
Topic: Detect Date Format & Change If Required?
Replies: 5
Views: 455

Re: Detect Date Format & Change If Required?

If the day is less than 13 you have no way of knowing which one it is. Is there a way of identifying if any of the first 4 characters are not numeric in one go, i.e. it would read 2024 as a number but 11-2 it would detect as not being a valid number, or do I need to check each character individuall...
by Dorian (MJT support)
Fri Nov 08, 2024 5:37 pm
Forum: Technical / Scripting
Topic: Check if String matches one of multiple options?
Replies: 3
Views: 240

Re: Check if String matches one of multiple options?

That's a remarkably clever way of using Separate. I just used Position. Also that's a good point re the case, which I hadn't thought of, so added it. Here's what I had : Let>SearchString=en-GB UpperCase>SearchString,SearchString LabelToVar>codes,codelist UpperCase>codelist,codelist Position>Searchst...
by Dorian (MJT support)
Wed Oct 23, 2024 4:00 pm
Forum: The Water Cooler
Topic: MS Help
Replies: 7
Views: 7202

Re: MS Help

F1 still launches context sensitive help, but we moved to online help quite some time ago.
by Dorian (MJT support)
Mon Oct 21, 2024 9:49 am
Forum: Technical / Scripting
Topic: Chromedriver disables Trusted Platform Module (TPM)
Replies: 6
Views: 904

Re: Chromedriver disables Trusted Platform Module (TPM)

Our hunch here is that ChromeDriver will not allow selenium to automate a chrome session that requires a hardware security method - for security reasons.
by Dorian (MJT support)
Tue Sep 24, 2024 9:13 pm
Forum: Technical / Scripting
Topic: Strip out specific characters from string
Replies: 9
Views: 2478

Re: Strip out specific characters from string

Not being a Regex guru, my approach would simply be to let that happen and then change it back again with another replace. I do realise that's somewhat of a bodge.

* "it's not wrong if it works" philosophy.
by Dorian (MJT support)
Mon Sep 23, 2024 6:21 pm
Forum: Technical / Scripting
Topic: Strip out specific characters from string
Replies: 9
Views: 2478

Re: Strip out specific characters from string

Many thanks. I'm always very grateful to the Regex gurus in here.
by Dorian (MJT support)
Mon Sep 23, 2024 11:08 am
Forum: Technical / Scripting
Topic: Strip out specific characters from string
Replies: 9
Views: 2478

Re: Strip out specific characters from string

I'd also be inclined use ReadFile instead of ReadLn and then Between/Regex to get anything between dc:title and />
by Dorian (MJT support)
Mon Sep 23, 2024 11:04 am
Forum: Technical / Scripting
Topic: Strip out specific characters from string
Replies: 9
Views: 2478

Re: Strip out specific characters from string

I think I'd do this in stages and take the approach of grabbing everything between content= and /> , use StringReplace to replace the &, then Regex to remove all non alphanumeric characters. But I'm no Regex expert - there may be others here who can do it all in one go. Let>TheHTML=<meta name="dc:ti...
by Dorian (MJT support)
Sun Sep 22, 2024 7:15 am
Forum: Technical / Scripting
Topic: Convert GetFileDate
Replies: 2
Views: 763

Re: Convert GetFileDate

GetFileDate : The date returned is in the format YYYYMMDD

DatePart : The date should be in a format recognised by the system.

We can use MidStr though.

Code: Select all

filedate>%Original%,fd

MidStr>%fd%,1,4,yr
MidStr>%fd%,5,2,mn
MidStr>%fd%,7,2,dt
by Dorian (MJT support)
Thu Sep 19, 2024 9:13 am
Forum: General Discussion
Topic: Macro Scheduler 15.0.25 released
Replies: 12
Views: 2772

Macro Scheduler 15.0.25 released

We have just released Macro Scheduler 15.0.25

For more details please see the Version History Page or this Blog post.
Sign up to our newsletter for free automation tips, tricks & discounts