replace logic in ETL

pavan_test · Post by **pavan_test** » Wed Jul 25, 2012 10:52 am

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

chulett · Post by **chulett** » Wed Jul 25, 2012 10:54 am

Search for the version of PXEReplace() posted here.

pavan_test · Post by **pavan_test** » Wed Jul 25, 2012 2:16 pm

is there any alternate approach convert and index functions?

can someone please let me know.

Thanks
pavan

jwiles · Post by **jwiles** » Wed Jul 25, 2012 3:03 pm

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,

DSXchange

replace logic in ETL

replace logic in ETL

Replace ETL Logic