transformation

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

True. But the solution is still straightforward using DataStage BASIC (for example in the BASIC Transformer stage). Convert the words into a dynamic array, take the leftmost character of each element, then delete the dynamic array delimiters.

Code: Select all

Convert(@FM, "", Substrings(Convert(" ", @FM, Trim(InLink.TheString)), 1, 1))
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”