I am trying to read a Fixed Width flat file using tFileInputPositional. However, there are a couple of things that needs to be ensured when the data is red from the source.
i. The trailing spaces for all fields needs to be trimmed.
ii. If the data present in the fields of the file consist only of '*' then we need to read the field data as ''. Whereas if the data consists of characters along with '*' then the data should be read as is. (eg:'****' or '***********' gets read as '' . But 'abc**erf*' gets read as 'abc**erf*')
Please suggest if there is any easier way of getting this done rather than dealing with each source field individually in a tMap.
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
Create systems and workflow to manage clean data ingestion and data transformation.