Format Concatenated Text

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Format Concatenated Text

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
  • October 12, 2021 at 2:35 PM #45465

    Anthony Compton
    Participant

    I have a database that contains user login info. Once I create the login info I need to paste it into a text box in another program. The output I’m looking for is:

    UserName: TomT
    EMail: TomT@domain.com
    Password: password

    I’m using this to concatenate the info:

    CONCAT(“UserName: “; USERNAME;” “;
    “EMail: “; EMAIL; ” “;
    “Password: “; PASSWORD)

    I want to insert a carriage return where the ” ” are, I tried inserting the ASCII for CR with no luck. Suggestions?

    Thanks

    October 12, 2021 at 2:53 PM #45466

    Daniel Leu
    Participant

    Try this: CONCAT("Line 1"; "\n"; "Line 2")

    October 12, 2021 at 5:00 PM #45467

    Anthony Compton
    Participant

    Thanks! That got me most of the way there. For some reason the second and third line are indented by one space but I”m a lot closer than I was. Hopefully I can track down where the space is coming from.

    Anthony

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.