Post reply

Expression in Precedence Constraints

  • November 14, 2011 at 1:50 pm

    #390855

    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

    #1407523

    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"

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • November 14, 2011 at 2:36 pm

    #1407542

    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