ETL and Data Integration tools - Modern ETL software for everyone

Hi

I have an Excel file with a field that contains 6k characters.
The Oracle 9i Varchar2 field that I have this Excel field mapped to is set at 4k.

I have created a new Oracle field of Varchar2(4000) and am trying to use the splitter to put the first 4k characters into the first field and the remaining characters into the second field.

I can't use the transformer as the GUI doesn't allow me to widen the cols enough, so I am trying to tweak the template bit.

Any ideas on what else I can do?

Kind regards,
Carlos

Carlos

I would just use 2 substring's instead of splitter I think it is just easier in your case

Peter

Excellent – thanks for your help.

Kind regards,
C