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