DSXchange

Hi,

how to replace a leading prefix with 'xyz'

Thanks in advance

You might want to give just a wee bit more detail... and an example.

adams06 wrote:Hi,

how to replace a leading prefix with 'xyz'

Thanks in advance

Please do the follwing steps in the same order

1) Open your online datastage help
2)Goto Search
type

try to use one or more of the functions listed to achieve your result

chulett wrote: You might want to give just a wee bit more detail... and an example.

Here are the examples

B-CDE PASS "NEED TO REPLACE B WITH XYZ"

A-HJU PASS "NEED TO REPLACE A WITH XYZ"

AHJU PASS "NEED TO REPLACE A WITH XYZ"

Thanks in Advance.

If you mean replace everything in front of the first "-" with something else. I think you have a few choices. One is using the FIELD function. The other is to use the INDEX function and substring notation.

Write a DS Function and test both of these:
or

And if you mean replace the first character with 'XYZ' - substring.

Try to make a small sub-routine like:


in1=Arg1
l=len(in)
new=right(in,l-1)
in2="XYZ"
Ans=cats(in2,new)

Sorry the variable names ....

in1=Arg1
l=len(in1)
new=right(in1,l-1)
in2="XYZ"
Ans=cats(in2,new)

Now its ok.

the following can save you a routine call

You can use the following derivation in a transformer Stage variable or output Derivation

Even shorted derivation:

Or: