Post reply

returning part of string with derived column transform

  • July 18, 2012 at 7:45 am

    #259089

    Newbie. I am reading data in from a text file. One of the fields is a product number and the filed length can vary. The issue is the data looks like 2266723.0 but I need it to look like 2266723. I simply need to return everything to the left of the decimal. Could someone help me the the expression syntax in the derived column transform to accomplish this? I would really appreciate it.

  • July 18, 2012 at 9:38 am

    #1514305

    It looks like you want to take a decimal and turn it into an integer. Try the Data Conversion Transformation instead of the Derived Column Transformation.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 18, 2012 at 10:36 am

    #1514350

    That worked! Thanks.

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

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