Multiple replace in one statement

[asyed]

Hi All,

I have a requirement where I need to perform replace of certain pattern in the entire string.

For eg:

Code: Select all

+Type abc +Type def +Type ghi

I want to replace this with:

Code: Select all

abc=Type-abc, def=Type-def, ghi=Type-ghi

Do I have to go for a routine (or) is there a way that this could be implemented in a single statement as the pattern is repetitive.
FYI - The number of times TYPE repeats is unknown.

[SURA]

I am not sure about "one statement"

Do you mean in a single record?

I trust, it can be handled with the help of stage variables.

DS User

[ray.wurlod]

Given the variable number of repeats, this may be able to be accomplished not with stage variables but with loop variables in a Transformer stage. You need at least version 8.5 for this functionality.