Splliting of 1 Input col into 4 Output cols on word boundary

[sambit]

Here is my requirement :-

My i/p column is 160 chars. I need to populate 4 o/p cols (each 40 chars) from this i/p col by splitting it on word boundary. How do I do so in Server edition.

Thanks in advance,
Sambit

[ray.wurlod]

Etiquette Note
When a problem has been solved, the OP marks the thread as Resolved and adds a post indicating how the problem was solved, to aid future searchers.

I suspect you used either the Fmt() or the Fold() function after searching the forum, but it would be nice to know exactly what you did do.

[sambit]

Hi All,
I am re-opening this thread inorder to get some better ideas from the forum. Please let me know incase of any solutions.

Thanks,

[chulett]

Better ideas than what? What have you tried so far?

[sambit]

Well... Actually we though thought of using the substring approach but it seems that this is the not the best approach when we are trying to split the data on Word Boundary. Data is being truncated.

[ray.wurlod]

Place a dynamic array, derived as follows, into a stage variable.

Code: Select all

Fmt(InLink.TheString,"40T")

Then use Field() functions with @TM as the delimiter to extract the four lines. For example, to extract the second line:

Code: Select all

Field(svChoppedLine, @TM, 2, 1)

The only change for the other lines is the third argument.