Variable as string in script

[jessica_webb]

I have a variable in my script as follows:

Set vAcadyear = 2016-17;

I then use this in several other places in my script (mostly in file names) which works just fine.

So

FROM

[$(vAcadyear)\Misc\Map.xls]

(biff, embedded labels, table is Points$);

Becomes

FROM

[2016-17\Misc\Map.xls]

(biff, embedded labels, table is Points$);

which is exactly what I want.

However, in another place in the LOAD statement I have:

LOAD

$(vAcadyear) as Year,

And that's not working as I want. In this case, it evaluates the variable, and gives me '1999' as 'Year' (i.e. 2016 minus 17!)

How do I get it to store this variable as a string, even though it "looks" like a calculation.

Thanks,
Jess

[jessica_webb]

Nope, still gives me '1999' as a value.

I'll upload a sample file on here.

[PrashantSangle]

Yes it is working properly.

Regards,

[jessica_webb]

I don't want it to say '1999' though. I want it to say '2016-17'

[tyagishaila · Accepted solution]

try it,

LOAD

'$(vAcadyear)' as Year,

[Anonymous]

Maybe: '$(vAcadyear)' as Year?

[PrashantSangle]

Hi,

try with single quote

Let vAcadyear = '2017-16';

Load ID,'$(vAcadyear)' as Year INLINE [

ID

1

2

];

Regards

[jessica_webb]

Thank you Shaila, that works perfectly