replace

[adams06]

Hi,

how to replace a leading prefix with 'xyz'

Thanks in advance

[chulett]

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

[prabu]

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

Code: Select all

string functions

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

[adams06]

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.

[kcbland]

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:

Code: Select all

Ans="XYZ":"-":FIELD(Arg1,"-",2,999)

or

Code: Select all

Ans="XYZ":Arg1[INDEX(Arg1,"-",1),LEN(Arg1)]

[chulett]

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

[urshit_1983]

Try to make a small sub-routine like:


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

[urshit_1983]

Sorry the variable names ....

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

Now its ok.

[ameyvaidya]

the following can save you a routine call

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

Code: Select all

"xyz" : in.col[len(in.col)-1]

[ArndW]

Even shorted derivation:

Code: Select all

"xyz":In.Col[2,99999]

[chulett]

Or:

Code: Select all

"xyz":In.Col[2,Len(In.Col2)]