I got an New Requirement where I will the Records in Single Column in a File. I would like to Extract the data in such a way that the Column Length should be greater than 255 Character's. After Picking the data again I need to split the Total String into 5-Different Field's the logic for each Field extraction is given below.
Field1 = trim(substr(5,8));
Field2 = trim(substr(13,40));
Field3 = trim(substr(53,40));
Field4 = trim(substr(93,40));
Field5 = trim(substr(133,5));
I have Tried tFlowToIterate Component to send the Recod's One By One, But am just messed up in Checking the Length's and getting the above logic done for
all the Records in the File. Kindly provide your feedback's on this.
Solved! Go to Solution.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.