Post reply

Expression help

  • July 26, 2020 at 5:26 am

    #3774794

    Hi,

    I am using this expression in precedence constrain. If it is true, then go to the next step.

    SUBSTRING(@FileName,"MyNetworkFolder\\xyz*.xls",1) > 0 ? "True" : "False"

    For some reason, the expression didn't like *. What I am trying to do here is. If the variable @FilaName has file name start with Xyz and extension only .xls

    Any thoughts?

  • July 26, 2020 at 4:09 pm

    #3774826

    "for some reason..."

    SUBSTRING() does not work with wildcards.

    Something like this should do the trick:

    upper(left(token( @FileName,"\\",tokencount( @FileName, "\\" )), 3)) == "XYZ" && upper(right(token( @FileName,"\\",tokencount( @FileName, "\\" )),4)) == ".XLS"?"TRUE":"FALSE"

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply