Passing multiple lines within one field

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Suman
Participant
Posts: 53
Joined: Thu Oct 07, 2004 8:28 am

Passing multiple lines within one field

Post by Suman »

Hi,
We have 4000 char field. We want to pass only 132 char per line such that there will not be any break of words in between for example if at the end of the word 'Class' the length is 135 then the whole word will come in the next line.So the previous line will have only 130 characters. Currently this is working fine if the value of the field is 250. We are using substring,index and right function and line breaks. If the value is greater than 250 then there is problem implementing the same logic as there is no loop inside transformer. If there is any other way of doing it then let me know.

Regards,
Suman
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Here are three possibilities:
1. Use a Build stage (BuildOp).
2. Create a parallel routine (in which there can be a loop) and invoke that from Transformer.
3. Use a BASIC Transformer stage and Fmt() and Field() functions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply