DSXchange

Hello

I have a scenario where my input File is delimited by ; and i need to produce a fixed width file.
I am using seqfilestage---colimport stage---transformer-seqfile
My input File looks like below with each field delimited by ;
abc;def;ghi,jkl

now iam parsing the four Feilds via Column import stage as 4 fields
The format i have mentioned in the format tab of the column import stage is
Final Delimiter=end
Field Delimiter=;
In the Column Import stage the SQL type i mentioned as Varchar

After parsing via Col Import stage and trimming each and every field in the transformer i still get one extra space at the end of every field.
Is it common if so how to delete those spaces.

thanks

The output i am getting in the target seq file is
abc def ghi jkl

Fixed-width files don't have field delimiters, what happens if you remove that property all together?

Hi Chulett,
My source File is ; delimited File.

Not talking about your source, but I see I misread your post anyway. You say you need to produce a "fixed width file" so we need to know what properties you have set in the target sequential file stage.

hi chulett,

I have mentioned the Final delimiter=end. I havent used any field defaults.

Could you post the metadata of the target sequential file.

Set the Field Width property for each of these fields.