Hello all, frustrated one here. What am I doing wront? Trying to CONCAT a couple of fields.
I am using a CALCULATED field, result value is Text
I have tried to CONCAT two numerics which works fine.
I tried to CONCAT two text fields works fine.
BUT in either case if I try to put a literal like ” ” (a space) or ” of ” (a word) between the fields I get nothing as output.
Please Help
Thanks
Hi Bernie,
Just use the + operator to concatenate them.
For example:
First Name + " " + Last Name
Make sure you use straight quotes also and not curly quotes.
-
This reply was modified 1 year, 9 months ago by
Brendan.
Ok thanks Brendan. By ‘straight quote’ I guess you mean the quote on the symbol line in the Calculation Formula correct? Not the ” in the ‘abc’ keyboard, correct?
I never kew there was a difference. thanks.
Bernie
The text editor tend to translate " " into something like ” “. It is only something to watch out for when copying text.
You can also hold down on the double-quote character on the iOS keyboard and you’ll see the variations. Pick the straight one.
Brandan Great, thanks. I been in this business over 40 years and Im still learning something new :)
Bernie
.
