trim Leading and trailing spaces without using transform stage in datastage

Question

I am trying to remove leading and trailing spaces in datastage. In Transform stage we can use TrimLeadingTrailing(ID) to achieve this. But without using transform stage , i am trying to use Modify stage . Below is the code

id = string_trim[" ",begin,end](id)

In any of the case by using String_Trim function , only leading or trailing spaces are getting removed. I am unable to achieve both the things.

Please help if there is any way.

Sample Input :

"    Abc  Yyyy    "

Sample Output:

"Abc  Yyyy"

score 0 · Accepted Answer · edited Jun 20 '20 at 09:12

0

Well look at the function definition this is obvious

string_trim[NULL, begin](name)

will remove all leading ASCII NULL characters from the beginning of name

string_trim['X', end, begin](text)

will remove all trailing X chars from text

Becasue of this "direction" you cannot do both at the same time

edited Jun 20 '20 at 09:12

Community

1
1

answered Jun 10 '19 at 09:57

MichaelTiefenbacher

3,805
2
11
17

Do we have any other way without using transform stage , can we do trim leading trailing. ? – avinash Jun 10 '19 at 10:27
Why do you want to avoid a transformer stage? – MichaelTiefenbacher Jun 10 '19 at 14:43
Actually we have multiple columns and lookups , which ends up using multiple transformers . – avinash Jun 10 '19 at 14:54
Multiple transformations can also be done in a single transformer in addition to that who said multiple are bad? – MichaelTiefenbacher Jun 11 '19 at 19:46

score 0 · Answer 2 · answered Dec 31 '20 at 08:11

0

There is also the Modify stage, which has four functions for dealing with trimming white space and other characters. But the Transformer stage has a more intuitive GUI.

answered Dec 31 '20 at 08:11

Ray Wurlod

831
1
4
3

trim Leading and trailing spaces without using transform stage in datastage

2 Answers2