- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 06-22-2018 11:33 AM
(783 views)
I have the product field with following info:
Product
Atrilin Amox HC Retin-A Micro
Tobi Cream Luzu Cream
I want the output as follows:
Product
Atrilin AmoxHC Retin-AMicro
TobiCream LuzuCream
I tried compbl function but it does not work.
I would appreciate any help with this.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
y = tranwrd(x, " Cream", "Cream");
@pp2014 wrote:
I have the product field with following info:
Product
Atrilin Amox HC Retin-A Micro
Tobi Cream Luzu Cream
I want the output as follows:
Product
Atrilin AmoxHC Retin-AMicro
TobiCream LuzuCream
I tried compbl function but it does not work.
I would appreciate any help with this.