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
replace logic in ETL
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Replace ETL Logic
is there any alternate approach convert and index functions?
can someone please let me know.
Thanks
pavan
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,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.