Joining texts in PropertyWizard – an alternative function

The third tutorial in PropertyWizard Help shows you how to join text values together using the ‘+’ operator:

PropertyWizard Formula window showing string concatenation formula using the '+' operator
Joining texts with the ‘+’ operator

As an alternative, you can use the strcat() function to join text values. This formula will have the same results as the one above:

PropertyWizard Formula window showing string concatenation formula using the strcat() function
Joining texts with the strcat() function

To use strcat(), you put the text values you want to join inside the parentheses, separated by commas.

Why strcat?

Why would you use one rather than the other? You might find strcat() more readable for large or complex formulas?

Why are there two ways of joining texts? I implemented strcat() very early in the development of PropertyWizard, and it was simpler at that time to create a dedicated ‘string concatenation’ function than to parse out two different meanings for the ‘+’ operator. I added text joining to the ‘+’ operator later, and didn’t remove strcat() in case people were using it. I always try to avoid making changes to PropertyWizard that will break your existing formulas.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.