DSXchange

I am getting a parameter for my job that includes one or more value for substring the main data. For example the value of the parameter is P_SUB=d[1,5].
On the stage variable in the job I am doing Ereplace(P_SUB,'d',LT_data.data).
So the result of the command in a flat file is 'assdfdd [1,5]' and not 'assdf'.
Any idea?
Thanks

What is the input value (LT_data.data), what is the expected output value, and what is the actual output value? What is the exact function call that you used? And, finally, what do you wish to achieve (in English, not in code)?

Please review, in on-line help or in the DataStage BASIC manual, the order of arguments in the Ereplace() function.

Originally posted and responded to here. Not sure why the repost except to (I suppose) perform the forum move.