Right justify using string_trim in Modify stage
Posted: Fri Mar 10, 2006 4:30 pm
Hello all,
I have a situation where I want to within a Modify stage:
a. Suppress a leading edge character.
b. Right-justify the resulting string
Column meta-data is as follows:
input - ColY Varchar (64)
output - ColX Char (15)
Test input value - "ggggggreen"
Specification = ColX:string[15] = string_trim['g',begin,end](ColY)
Output - "......reen....." (A dot is used to represent an actual space)
Specification = ColX:string[15] = string_trim["g",begin,end](ColY)
Output - " ......reen....." (A dot is used to represent an actual space)
Test input value - "ggggggreenxxxxxxxxxxxxxxx"
Specification = ColX:string[15] = string_trim['g',begin,end](ColY)
Output - "....reenxxxxx" (A dot is used to represent an actual space)
The output suppresses the leading edge 'g's but does not right-justify. I have looked within the Orhestrate 7.0 Operators Reference and have not found any help as this function is undocumented.
Any help would be appreciated,
I have a situation where I want to within a Modify stage:
a. Suppress a leading edge character.
b. Right-justify the resulting string
Column meta-data is as follows:
input - ColY Varchar (64)
output - ColX Char (15)
Test input value - "ggggggreen"
Specification = ColX:string[15] = string_trim['g',begin,end](ColY)
Output - "......reen....." (A dot is used to represent an actual space)
Specification = ColX:string[15] = string_trim["g",begin,end](ColY)
Output - " ......reen....." (A dot is used to represent an actual space)
Test input value - "ggggggreenxxxxxxxxxxxxxxx"
Specification = ColX:string[15] = string_trim['g',begin,end](ColY)
Output - "....reenxxxxx" (A dot is used to represent an actual space)
The output suppresses the leading edge 'g's but does not right-justify. I have looked within the Orhestrate 7.0 Operators Reference and have not found any help as this function is undocumented.
Any help would be appreciated,