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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers