Checking empty field

Viewing 3 reply threads
  • Author
    Posts
  • January 31, 2023 at 6:37 PM #48814

    SMXSteve
    Participant

    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.
    January 31, 2023 at 8:22 PM #48816

    Daniel Leu
    Participant

    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.

    January 31, 2023 at 10:42 PM #48818

    Brendan
    Keymaster

    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.

    February 1, 2023 at 8:02 AM #48819

    SMXSteve
    Participant

    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…

Viewing 3 reply threads

You must be logged in to reply to this topic.