Posted: Tue Mar 19, 2013 3:00 pm
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))