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"
November 14, 2011 at 2:36 pm
Thanks Phil!
It worked.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy