I have the following problem:
For an email robot I want to use the subject as a variable. This should be used in a flowchart as a decision base. However, a part of the variable is unknown and is determined by the user.
How can I put a placeholder in such a variable?
Excel with the count-if function serves as an example:
=Count-If(A2:A5; “") with the placeholder "”.
Here’s what I had in mind (which didn’t work):
Variable = * & “Text”
Thanks for the answers! Unfortunately, I have expressed myself somewhat incomprehensibly.
My goal is to perform a decision in the FlowChart by a string (email subject). Here I want to trigger different applications by different subjects (e.g. animals, countries, colors). However, each category has subcategories e.g. DE_country, ES_country, IT_country. So that the program recognizes the supercategory country with special email subjects, I would like to make the checking variable.
The program should ignore the first letters and only look at the rest **_country. A split is not possible, because some words have 3 code digits in front of them e.g. RED_Color.