Post reply

Trouble splitting the values of a column into multiple columns

  • May 12, 2010 at 8:47 am

    #146937

    Hi,

    I'm reading data from a flat-file, and the data is in the following format:

    Table=A, Column=B, Data=C

    Table=D, Column=E, Data=F; Table=G, Column=H, Data=I

    Table=J, Column=K,Data=L; Table=M, Column=N,Data=O; Table=P, Column=Q,Data=R

    I have three destination columns called Table, Column and Data, into which I would like to insert the respective values.

    The catch is, I don't know how many times the same Table-Column-Data combinations will occur in a single record. I am looking to get an output like this:

    TABLECOLUMNDATA

    ===============

    ABC

    D/GE/HF/I

    J/M/PK/N/QL/O/R

    and so on, where multiple values are put into the same column, delimited by a '/'.

    I've been trying quite a few approaches but I've not been able to achieve this so far. It would be great if someone could help me out here.

    Thanks!

    Regards,

    GS

  • May 12, 2010 at 9:01 am

    #1166296

    That's quite unpleasant.

    You will need to read in the source data as a single string (no column delimiter) and then use a Script Component to parse & reformat the data for output to three columns. I don't see any way that can do it without a chunk of code.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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