You need to sign in to do that
Don't have an account?
Linda 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!!
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!!
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,
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.