Parsing delimited data within a single data field

brianlees

• March 26, 2014 00:00

• Answered

Follow

We have an Excel spreadsheet that contains delimited data within a cell. The data in the single cell is delimited with "/". Can someone point me to the sections of the manual on how I can extract the data from this field and create completely new data fields from it. Basically, I want to take this one field and turn it into seven different data fields. I assume this would be via the Reformat transformer?

• 

  imriskal

  • March 27, 2014 09:38

  0

  Comment actions Permalink

  Hi Brian,
  
  You can use split function in CTL code of Reformat. Here is more information about the function: http://doc.cloveretl.com/documentation/ ... ctl2-split
  
  Please see my example graph.
  excel_delimited_value.zip
  Regards,

  • excel_delimited_value.zip
• 

  brianlees

  • March 28, 2014 12:33

  0

  Comment actions Permalink

  I'm having problems opening this file. Is it because I have the community version?
• 

  imriskal

  • March 28, 2014 14:25

  0

  Comment actions Permalink

  I am sorry, the example was made for commercial Designer. Here is a modified graph for community edition, SpreadsheetDataReader has been replaced by XLSDataReader.
  excel_delimited_value_modified.grf
  Regards,

  • excel_delimited_value_modified.grf

Please sign in to leave a comment.