Post reply

Derived Column Syntax Help

  • January 29, 2014 at 9:30 am

    #396187

    I need syntax help with with the expressions of two columns (SSIS 2008). I have a variable called @[User::Test]

    that outputs CAT.DOG, MOUSE.MOOSE, etc. etc

    I need the first column to grab everything BEFORE the "." and

    the second column to grab everything AFTER the "."

    Example:

    Column 1: CAT.DOG becomes CAT

    Column 2: CAT.DOG becomes DOG

  • January 29, 2014 at 9:51 am

    #1684385

    Something like this...

    Col1 : SUBSTRING(@[User::Test],1,FINDSTRING(@[User::Test],".",1) -1)

    Col2 : SUBSTRING(@[User::Test],FINDSTRING(@[User::Test],".",1) +1,LEN(@[User::Test]))

  • January 29, 2014 at 10:04 am

    #1684399

    Thank you!

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

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