how to read a BLOB in Oracle et break this Blob into different columns

One Star

how to read a BLOB in Oracle et break this Blob into different columns

Hello,
I need to read an Oracle table that contains a BLOB column. This column will contains comma separated values.
I need to load this BLOB column into different columns in another Oracle table.
The data in this BLOB (or CLOB) may look like this : 2012-05-08;john;doe;canada;123;street name;city;province;

In fact, I want to take the value "2012-05-08" and store it in a column, take the value "john" and store it in another column, take the value "doe" and store it in another column, etc...
I've searched the Internet for examples but I haven't found anything helpfull.
The source column could also be a CLOB.
How can I make Talend separate the BLOB/CLOB column in multiple varchar columns ?
THank you
Pascal Beaudoin
Community Manager

Re: how to read a BLOB in Oracle et break this Blob into different columns

Hi
Here is a good demo for reading Blob/Clob type from Oracle as a stream.
http://www.talendforge.org/forum/viewtopic.php?id=13711
and then use tFileInputDelimited with 'use stream' option to read the stream, link it to a tExtractFileDelimited to extract one column to multiple columns.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business