Showing posts with label DS Trim function. Show all posts
Showing posts with label DS Trim function. Show all posts

Monday, June 30, 2008


PREVIOUS



2.16. Datastage trim function cuts out more characters than expected


By deafult datastage trim function will work this way:


Trim(" a b c d ") will return "a b c d" while in many other programming/scripting languages "a b c d" result would be expected.

That is beacuse by default an R parameter is assumed which is R - Removes leading and trailing occurrences of character, and reduces multiple occurrences to a single occurrence.

To get the "a b c d" as a result use the trim function in the following way: Trim(" a b c d "," ","B")



NEXT