+ Start a Discussion
Linda 98Linda 98 

Parse a string in Workflow

I am trying to get the mid part of the string in my flow and use the string

Like    Hello:  Linda Klein :Thank you

I would like to get Linda Klein.As i am having other various conditions,I have to check if my string begins with Hello and contains thank you.
I have written it as below but i dont get value in my field update.
Where am i going wrong.


IF( AND( BEGINS(Info, 'Hello: ') ,(CONTAINS(Info, ':Thank you'))), MID(Info, FIND("Hello: ", info )+ 6 , 
(FIND(": Thank you", info )-11) - (FIND("Hello: - ",Info ))),info)

nO error..no value in field.I am struck.

Thanks!!
Jithesh VasudevanJithesh Vasudevan
Hi Linda,

I tried your code and it did nothing for me too.
So I had to break yours and tried mine.

Here it is,

Workflow rule,
User-added image

Here your criteria should be "Info Not Equal To Null".

Then field update. Here you have to give the below formula,

IF(AND(BEGINS(Info, 'Hello: ') ,CONTAINS(Info, ':Thank you') ),TRIM(SUBSTITUTE(SUBSTITUTE(Info, 'Hello: ', '') , ':Thank you', '')) ,'')

Hoping "Hello:" and ":Thank You" will be there in the text always and only the name changes.