Find text position returns -1

[Ssp_power]

Please refer to the embedded screenshot. I have tried to get offset of string "type=" in the message and it returns -1. What is wrong here ? What should be done to get the correct offset ?

[ekarim2020]

Do you mean that you want to extract the substring string 'story' from the string 'create type=story title=abcde'?

Ellis

[Ssp_power]

Hi Ellis,

I realized that I had flipped "Text" and "Search Text" and hence I was getting -1 as the offset. I swapped these and I got it. Now based on your reply, am curious, how do I parse the key value parameters ? 

[ekarim2020 · Accepted solution]

Will type and title only contain single words such as:

type=story title=abcde

Or Will type and title contain multiple words such as:

type=non fiction title=Travel to Mars

Do you want to extracts both type and title? To extract type and title - when they are single words only - you can use the following expressions:

Type:
trim(first(split(last(split(variables('varText'),'type=')), 'title=')))

Title:
Last(split(variables('varText'),'='))

 

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

[Ssp_power]

Thanks Ellis. Yes, the values would be phrases (not just words). I will take it from here.