Post reply

Extract data into different columns

  • January 14, 2011 at 4:42 am

    #97622

    Hi there,

    I have a set a data with the same data in all columns besides the tel no column and un. I have to import the data into a table and each telno no for each location name into a different column eg:

    Location IDTelephone NoLocationLocation CodeLocation Owner

    15558754Arizona5555Abraham Lincoln

    15559542Arizona5555Abraham Lincoln

    15555623Arizona5555Abraham Lincoln

    15551215Arizona5555Abraham Lincoln

    15551132Arizona5555Abraham Lincoln

    15553211Arizona5555Abraham Lincoln

    25358941New York 4444Anrnold Null

    2535412New York 4444Anrnold Null

    25354123New York 4444Anrnold Null

    25354789New York 4444Anrnold Null

    25354562New York 4444Anrnold Null

    25356541New York 4444Anrnold Null

    I need to write a script that will return Arizona in one field but have the different telephone numbers in different columns. eg: telephone no1, telephone no2, telephone no 3 etc.

    Can anyone please assist?

    Regards

    IC

  • January 14, 2011 at 5:19 am

    #1273473

    Please have a look at the CrossTab article referenced in my signature.

    I'm sure this concept will help to resolve the issue.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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