Replace every string after 1st occurrence

[nujjod]

I have a data that looks like this:

Fruits

Banana - Pineapple - Grapes - Pineapple - Apple

Apple - Grapes - Pineapple - Pineapple - Pineapple

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

[atcodedog05 · Accepted solution]

Hi @nujjod 

Here is how you can do it.

Workflow:

Hope this helps : )

[nujjod]

Thank you so much 🙂

[atcodedog05]

Happy to help : ) @nujjod 

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

[atcodedog05]

Hi @nujjod 

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