Parsing Flat Pip Delimted File

sharpiedog

• April 05, 2013 00:00

• Answered

Follow

I can't seem to find the right component to parse out 100's of lines like the following:

Example:
Donald|Duck|k|M|ABC;DEF;COM|999740201|000399999715|M111232622;11111.0;W09876578

The end result needs to read:
Donald|Duck|k|M|ABC|999740201|000399999715|M111232622
Donald|Duck|k|M|DEF|999740201|000399999715|11111.0
Donald|Duck|k|M|COM|999740201|000399999715|W09876578

Pairing is done off Field 5 & 8.

Thanks for your help

• 

  imriskal

  • April 08, 2013 09:01

  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,
• 

  sharpiedog

  • April 08, 2013 13:38

  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
• 

  admin

  • April 09, 2013 07:49

  0

  Comment actions Permalink

  Hi Andy,
  
  it is language called CTL2. Documentation is available here: http://doc.cloveretl.com/documentation/ ... /ctl2.html
• 

  sharpiedog

  • April 09, 2013 17:41

  0

  Comment actions Permalink

  Thank you very much, I really apprecaite it.

Please sign in to leave a comment.