Failed to Compile test harness

[pmadhavi]

Hi
We are using Datastage 7.1r1 in Windows.
I have to remove comma froma string. I am not able to use Ereplace or Convert or any other similar function in the transformer.

So I created a test routine in the manager.
Routine definition: Ans=Ereplace(Arg1, " ","")
It is compiling without any errors.
But when I run it, it is throwing the following error.

TEST #1
*******

Arg1 = New York

Failed to compile test harness

Are these functions not compatible with DS7.1 version.
Please suggest me the work around for this.

[chulett]

What turns up if you put 'Failed to compile test harness' into the Search function here? More than likely, the answer to your question!

[pmadhavi]

What turns up if you put 'Failed to compile test harness' into the Search function here? More than likely, the answer to your question!

I did not find any posting similar to my problem. I don't understand what does the error mean. Pls help me

[DSguru2B]

Your routine doesnot remove a comma from the string, it only removes spaces.
You need to use

Code: Select all

Ans = Ereplace(Arg1, ",","") 

It should work even in the transformer. Use the above code directly in the transformer, without the Ans = offcourse, and Arg1 will be replace by in.col

[ray.wurlod]

I am not able to use Ereplace or Convert or any other similar function in the transformer.

Why not?