Need help for one scenario

[manojbh31]

Hi,

I have one scenario which i need to implement.
Source is feed file which contains one coulmn EmpName and data in this field in around 300 length string. Please find the output in the below eg

Eg: consider the string as abcd2efgh3hijk4................ which is coming from feed file

and the output should be in single column as follows. It should be 1-5 as first record and 5-10 as second records and so on

EmpName

abcd5
efgh3
hijk4

Please let me know how to implement this scenario in DS server jobs

[ArndW]

In a transform stage make a output column derived from In.Col[1,5]:Char(10):In.Col[6,5]:Char(10):In.Col[11,5] and so on. This adds a <LF> to the output string and when that file is read again it will read in one value per row.

[manojbh31]

Hi,

I am not able to get your answer what u explained. can you please ellobarate please

[ArndW]

Sequential files are split into "records" by using <cr><lf> (windows) or just <lf> (UNIX). By manually adding these characters to a string, you create new records. So in your case if there are 3 columns to split, you would read one record, add char(10) three times and do one write. But when that is read again, it will contain 3 records.

[chulett]

FAQ posting on this very subject. FYI.