Customer Portal

Parsing Flat Pip Delimted File

Comments 4

  • Avatar
    imriskal
    0
    Comment actions Permalink
    Hi, sharpiedog,

    Normalizer is the component you are looking for. Assuming that number of items in field5 is equal to number of items in field8, you can use Normalizer with CTL code like this:
    function integer count() {
    return length(split($in.0.Field5,";"));
    }

    function integer transform(integer idx) {
    $out.0.* = $in.0.*;
    $out.0.Field5 = split($in.0.Field5,";")[idx];
    $out.0.Field8 = split($in.0.Field8,";")[idx];
    return OK;
    }

    Best regards,
  • Avatar
    sharpiedog
    0
    Comment actions Permalink
    Thank you so much for your reply & help. I will test out the normalizer & post back.

    What is the best reference to study how on how make these functions? Is it a certain language like java, php, etc..? I am still new & trying to learn & leverage the CloverETL tool within Initiate.

    Thank you,
    Andy
  • Avatar
    admin
    0
    Comment actions Permalink
    Hi Andy,

    it is language called CTL2. Documentation is available here: http://doc.cloveretl.com/documentation/ ... /ctl2.html
  • Avatar
    sharpiedog
    0
    Comment actions Permalink
    Thank you very much, I really apprecaite it.

Please sign in to leave a comment.