Concat, variables problem

General Macro Scheduler discussion

Moderators: JRL, Dorian (MJT support)

Post Reply
User avatar
Bob Hansen
Automation Wizard
Posts: 2475
Joined: Tue Sep 24, 2002 3:47 am
Location: Salem, New Hampshire, US
Contact:

Concat, variables problem

Post by Bob Hansen » Wed May 14, 2003 8:25 pm

Using 7.2.036

In some version after 4/24/2003 a problem has been introduced.
Lines that did concat are no longer evaluating properly. There is no statement for Let>VAREXPLICIT=x


Code that worked hundreds of times in versions prior to 4/24:
Input>ftpfiledate,Please enter the Monday date to be downloaded. MMDDYYYY format.
Let>ftpfilename3=105%ftpfiledate%
Concat>ftpfilename3,-2003
For an input entry of 05122003, this would result in ftpfilename3 = "10505122003-2003"

But this now results in ftpfilename3="10505122003%-2003%"
(treats the addition as a variable).
=================================

I added the line Let>VAREXPLICIT=1, with no difference.
I added the line Let>VAREXPLICIT=0, with no difference.
Both instances result in ftpfilename3="10505122003%-2003%"

I changed to Concat>%ftpfilename3%,-2003, with VAREXPLICIT set to 1 and 0, with no difference.
=============================

To workaround this, I tried:
Let>ftpfilename3=105%ftpfiledate%
Let>ftpfilename3=%ftpfilename3%-2003

That resulted in ftpfilename3="10505120000" (did a subtract vs. appending).
================================

Final workaround at this time is:
Let>ftpfilename3=105%ftpfiledate%
Let>ftpfilename3=%ftpfilename3%-
Let>ftpfilename3=%ftpfilename3%2003

This results in ftpfilename3="10505122003-2003" as always worked in the past.
====================

Conclusion: Concat is not working properly in 7.2.036

Final solution also should not require going back to Concat> undeclared variables and adding %....% symbols. Earlier scripts had no VAREXPLICIT to deal with, and default =0.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

User avatar
Bob Hansen
Automation Wizard
Posts: 2475
Joined: Tue Sep 24, 2002 3:47 am
Location: Salem, New Hampshire, US
Contact:

Post by Bob Hansen » Fri Jun 06, 2003 5:45 am

Just a reminder before next release......

Others having same problem?
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts