Post reply

Separate Data in a Derived Column

  • January 8, 2013 at 8:17 am

    #269072

    Hi,

    I have an address field on a .csv file which is too long where information after a comma needs to be separated out into an additional existing column- example below

    Address 1 - Fairfield,Goodwood Gardens, Runcton

    Is it possible to write a query to move the information after the comma or after the second column to Address 2?

    Help appreciated as always

    Thanks,

    Tom

  • January 8, 2013 at 8:30 am

    #1574852

    Hi

    This link should help you

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • January 8, 2013 at 9:03 am

    #1574870

    Thank you- I have another question relating to the same file.

    I have two columns in the CSV file, Contact Name and Company. The Contact Name is duplicated in the Company Name if there is no company name provided. Is it possible to write an expression to replace the Company name with NULL if it matches the contact name?

  • January 8, 2013 at 10:43 am

    #1574929

    tom 100 (1/8/2013)

    Thank you- I have another question relating to the same file.

    I have two columns in the CSV file, Contact Name and Company. The Contact Name is duplicated in the Company Name if there is no company name provided. Is it possible to write an expression to replace the Company name with NULL if it matches the contact name?

    You could use a Derived Column Transformation to handle that case.

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

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

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