I want to check if the HTML text contains the words like MP4, or WMV then I want to map the yes/no filed as yes and if it does not contain those words then I want to map it as No.
To do this I am simply extracting the HTML text with regex using the expression “\b(mp4|wmv)\b”
However, I am not getting an option to map Yes no Value from here based on the output.
Its result is yes/no. So if the field (email with video) is yes/no as well, they will match. If that field is text, then you have to continue with format as text.
Yes, the field is yes/no. So I am assuming that with the current workflow if the extracted data count is greater than 0 then it will automatically be set to yes and if the result is 0 then it will be set to No.