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
Dynamic substring
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Please review, in on-line help or in the DataStage BASIC manual, the order of arguments in the Ereplace() function.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Originally posted and responded to