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?
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,
I’m having problems opening this file. Is it because I have the community version?
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,