How to create a beast mode for 1st initial of first name and add the last name

Abe
Abe Member
in Beast Mode

Hi everyone,

I'm having issues trying to get a beast mode to work when trying to get the 1st letter of the first name and adding it to the last name.

This is what I have - SUBSTRING('Ticket_Owner_First_Name',1) + 'Ticket_Owner_Last_Name'

I've tried different variations of this but can't seem to get it correct.

Any assistance is greatly appreciated.

Thank you

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    Try this:

    CONCAT(LEFT(TicketOwnderFirstName,1),TicketOwnerLastName)

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    Try this:

    CONCAT(LEFT(TicketOwnderFirstName,1),TicketOwnerLastName)

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Abe
    Abe Member

    @MarkSnodgrass

    Thank you sir for the assistance!

    When testing different formulas I also tried concat but did not use the " Left" function inside the parenthesis.

    Thank you again for the assistance.

Categories