DSXchange

Hi,
I need to extract data from a source file. Format of the file is as below

COLUMN - A|B|C|D|E
ROW1 - 45|56|67|23A||
ROW2 - 45|56|67|23A||
ROW3 - 45|56|67|23A|Sam
ROW4 - 45|56|67|23A|Martin
ROW5 - 45|56|67|23A|Sunny
ROW6 - 45|56|67|23A|Keaubu

I'm using Sequential file stage to extract the data and below are the properties set in the Format tab of the Sequential file stage.

Record level
Final delimiter :end
Record delimiter :UNIX newline

Field defaults
Delimiter :'|'
Null field value = ''
Quote = none


With these settings, I'm able to read the data but the last column has '|' value for ROWS 1&2.

**************************
If I change the settings as below

Record level
Final delimiter :'|'
Record delimiter :UNIX newline

Field defaults
Delimiter :'|'
Null field value = ''
Quote = none

ROWS 3,4,5,6 are dropped with warning "Delimiter for field not found"
**************************

Please guide me on how to solve this issue.

Get rid of the Final Delimiter property. This asserts that there is an extra delimiter character between the last field and the end of the record, which is not the case in your data.