How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
Answer Posted / msbharathi
In sequential file stage use the filter in the options
In filter use sed '1d;$d'
You can use sed '<start>,<end>d' to delete particular rows and use sed -n '<start>,<end>p' to keep particular rows
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
To see hidden files in LINIX?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Define data aggregation?
How a source file is populated?
What is the purpose of pivot stage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
what is flow of project?
what is the difference between == and eq in UNIX shell scripting?
How we can covert server job to a parallel job?
root tree will find which is server job and which is parallel job?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is datastage?
How do you import and export data into datastage?
What is ibm datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?