Alteryx Designer Desktop Discussions

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

How to find last occurrence of particular word in string

Arti2893
7 - Meteor

Hi Team,

 

I want to find last occurrence of word "Status:5" in a string and replace it with "'Status:2".

 

Please note that the string is dynamic. Can someone please help 

1 REPLY 1
aatalai
14 - Magnetar

Try this in the formual tool

 

 

Reversestring(replacefirst(ReverseString([feild]),"5:sutatS","2:sutatS"))

 

@Arti2893 let me know how you get on

Labels