We're just warming up the Strata blog right now, but we going to be adding various tips and tricks on how to use the software more effectively. One aspect of this will be to discuss general support questions we receive that have relevance to many users.
So, along those lines, we received a question the other day about concatenating fields together into a single string. Excel has a CONCATENATE function that will let you take two non-numeric columns and place them together. Here's an example from the Excel help manual:
CONCATENATE("Total ", "Value") equals "Total Value"
Strata makes this even easier, since no function is required to concatenate or join strings together. You simply need to add them together:
"Total " + "Value" equals "Total Value"
So, say you had a table with a first name field (”firstname”) and a last name field (”lastname”) and wanted to put these together. You would insert a new calculated field and enter the following formula:
firstname + lastname
So, if a record had “John” in the firstname field and “Smith” in the lastname field, you would get a result of:
The spacing is obviously problematic here, so we just need to add in a space for formatting purposes:
firstname + " " + lastname
which would result in:
So, to sum up, no concatenate function is necessary when using Strata… just add your strings together.