November 14, 2011 at 1:50 pm
Hi,
Is it possible to use a Like operator in the expression for precedence constraint?
I am trying something similar to the following expression:
@FileName Like "NewProducts*.txt"
Based upon what the file name is, i need to execute different tasks.
And the filenames have a date stamp appended to it. So i can't really use an "==" operator.
Thanks.
November 14, 2011 at 2:05 pm
Don't think so. But you can use a combination of SUBSTRING and RIGHT to achieve the same thing - something like this (untested):
UPPER(SUBSTRING(@FileName,1,11))=="NEWPRODUCTS" && UPPER(RIGHT(@FileName,3))=="TXT"
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
November 14, 2011 at 2:36 pm
Thanks Phil!
It worked.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply