This is probably a known issue, but I’ve found that even though the Help display for the Concat function shows the argument delimiter as being a semicolon, a comma will work as well. One side effect is that when trying to concatenate street, city, state, and zip code, fields, I wanted to add spaces and commas to separate some of the text. Concat(Address Street;”, “;Address City…… It appears as though the parser interprets the comma in the string field as a delimiter, which causes an error. Or at least, I get no concatenated string when I do this. Using a simple + (plus) between field names and separators solves this. At least it did for me. Hopefully, this might help someone.
Hi Gary,
A long time ago the delimiter used to be commas, then I changed it to semi-colon. But I didn’t want formulas created before to fail, so it works for both. But ya, this issue can happen then.
And you’re right, the solution is to just use the + operator.
[Last Name] + ", " + [First Name]
would do it.
.
