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
Passing multiple lines within one field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.