DSXchange

I have input data coming in as below. can someone please tell me how do i replace Customer with Yamaha without changing rest of the data in the input.

input data:
Customer PIN Number


Desired outputdata:

Yamaha PIN Number

Thanks
Pavan

Search for the version of PXEReplace() posted here.

is there any alternate approach convert and index functions?

can someone please let me know.

Thanks
pavan

You could use Index() and concatenate substrings together...fairly simple if you're expecting only one instance of your target in the string, but difficult if you may encounter the target multiple times and need to replace more than the first occurrence.

Regards,