Post reply

ActiveX script

  • June 24, 2008 at 7:55 am

    #75248

    Hello all,

    I am trying to convert bad data during transformation with an activeX script. I have used the following script successfully, but need to adjust the script for varying numbers of asterisks. I looked into wildcards but found that the wildcard character is an asterisk. What are some alternatives?

    If DTSSource("Col031") = ("********") Then

    DTSDestination("Column31") = -100

    ELSE DTSDestination("Column31") = DTSSource("Col031")

    End if

    Thanks,

    DK

  • June 24, 2008 at 1:11 pm

    #833562

    If you can assume that one asterisk means bad data, then why not just use the LEFT function?

    If Left(DTSSource("Col031"), 1) = "*" Then

  • June 30, 2008 at 9:12 am

    #836195

    Thanks Erik,

    That works for me!

    Thanks again,

    DK

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

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