DSXchange

HI ,

Can any one tell me abt the syntax to use in Modify stage for Trim function.

Thanks in Advance

That wil be string_trim()

You have posted in the wrong forum.

This syntax is enough for removing all leading and trailing spaces.

Is your copy of Parallel Job Developer's Guide broken?

Not sure if this is in Parallel Job Developer's Guide. This is the syntax : This function can be used to trim occurrences of a character from the beginning or end of a string.
Ex: But you cannot trim both leading and trailing spaces using this function.

Good catch. However it IS in the Orchestrate Operators guide. Page 13-19 in the version 7.5 manual. Curiously, string_trim does not appear in the version 7.0 Orchestrate Operators guide.

Can any one send me Orchestrate Operators guide 7.5 version

Thanks George

You support provider can supply the Orchestrate manuals at no charge for the asking.

Seems the Trim functions doesnt work in the modify Stage. i tried the option in Orchestrate manual and also tried the one given here , but it is not triming the spaces.

I used string_trim() and also tried with strip_whitespace () and trim_leading_trailing command. it doesnt work

Please let me know if there is anything different.

Manish

Please provide the exact syntax you used for string_trim(). It works OK for me on version 7.5.1A on Linux.

Here is my data in column n1 :

"Hello World"
and " Hello "

Here is my syntax :

1 . n3 : string = string_trim (n1)
2. n3 : string = strip_whitespace(n1)
3. n3 : string = trim_leading_trailing(n1)

This is not stripping the white spaces.

Data stage is running on AIX 3 5

Thanks
manish

I wonder if it's because of the unbounded string specification of the data type. Try

I copied a bunch of Modify Stage code from the DataStage and Orchestrate guides into this wiki. Sh, don't tell IBM. The string_trim is in there. Was thinking it would be a good place to add sample code but never got around to it. Feel free to modify it.

There's as complete a list of Modify stage functions as I've been able to construct here

Thanks Ray. The List of Modify stage functions pdf which you send is very helpful. I was looking at the 7.0 orchestrate manual for the string_trim and couldnt find it and then browsed the forum. This list helps.