Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replace every string after 1st occurrence

nujjod
6 - Meteoroid

I have a data that looks like this:

 

Fruits
Banana - Pineapple - Grapes - Pineapple - Apple
Apple - Grapes - Pineapple - PineapplePineapple

 

And I want to replace the word Pineapple with Apple after its first occurrence so the output would be:

 

Fruits
Banana - Pineapple - Grapes - Apple - Apple
Apple - Grapes - Pineapple - Apple - Apple

 

Thank you so much

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @nujjod 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1640976517116.png

 

Hope this helps : )

nujjod
6 - Meteoroid

Thank you so much 🙂

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @nujjod 

Happy new year to you and your close ones : ) May it be filled with happiness and prosperity =D

atcodedog05
22 - Nova
22 - Nova

Hi @nujjod 

 

Thank you for the opportunity I just solved my first solution for the year 2022 🙂

Labels
Top Solution Authors