This works until I put the , in between the “” (had to do a screen shot to show the fields)
Thanks
Steve
Attachments:
You must be
logged in to view attached files.
You need to escape the coma like "\,"
.
See paragraphs Text Concatenation and Quoting Special Characters at the bottom of https://www.tapforms.com/help-mac/5.3/en/topic/calculation.
Side-note: You kind of mix two things together. You use concat()
to concatenate a string that is already concatenated by using +
. So maybe just use concat("a"; "\, "; "b")
instead.
Also you don’t need to use the CONCAT
function. You can simply add the strings together. Like you’ve done within the parameter of the CONCAT
function. It’s a bit of a redundant function.
Thanks for the responses. I’ve only been using this a couple of days. Now I see if I had scrolled down to the bottom on the function page I’d find what I was looking for. I’m an old VB SQL developer, I knew it was something like that… I saw CONCAT in one of the videos thought it might provide a simpler approach but I managed to take it further…