We need to build a component called tFileInputDelimitedExtract. You could use tFileInputCSVFilter as a reference for the implementation. Unfortunately I don't have the time at the moment for this implementation but at least let me enunciate the specifications for it in case someone decides to go further with the implementation. It could be a good project for someone willing to learn talend component creation for example.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Narrative | |
========= | |
* As a Talend user | |
* I want a component called tFileInputDelimitedExtract | |
that accepts an input delimited file, | |
the delimiter and a list of column names | |
and generates as output *just* the columns in the specified list order | |
* So that I can guarantee a fixed schema | |
independent of the order or the number of future columns. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
cut -d'|' -f1-6,8-100 ~/input.bcp > ~/output.bcp |
No comments:
Post a Comment