AnsweredAssumed Answered

Splitting field data in token

Question asked by Nicol Maurer on Jun 15, 2016
Latest reply on Jul 9, 2016 by 598b656eb8fa8ed8030f6743a8e0699ca38309fb

Like • Show 0 Likes0
Comment • 9

Has anyone written a token script that will return only part of a data field? I use our Salesperson token often, which will return their full name. I would like to make it a little more personal by only returning the first name. I've tried scripts to split the data in the field, returning only what it before the first space in the field, but have had no luck. I'm not a developer, nor do I have one at my disposal--so my knowledge of how to use what I find on the Internet is limited. Please let me know if anyone has accomplished this.

No one else has this question

Outcomes

Nicol Maurer Jun 15, 2016 9:24 AM

Right now I have:

#set ($name = ${lead.Salesperson})

#set ($repfullname = $name.split(" "))

$repfullname[0]

Returns: $repfullname[0]

Actions

Jamie Lewis

Jun 15, 2016 10:50 AM

Have you tried using the substring method? I think that will solve it.

Actions

Nicol Maurer @ Jamie Lewis on Jun 15, 2016 10:57 AM

Thanks for your reply. I'm actually trying to get the {lead.Salesperson} value assigned to the $name variable. It's not currently assigning, or if it is, it's being assigned as an object and not a string.

Actions

Jenna Molby

Jun 15, 2016 2:21 PM

Your logic is correct. What displays in the email when you do a test send?

Actions

Nicol Maurer @ Jenna Molby on Jun 16, 2016 10:06 AM

It just displays ' $repfullname[0]'.

When I assign lead.SalesPerson to $name the value of $name isn't what is expected. It's blank. If I give lead.SalesPerson a default value it will display the default value. It seems a bit buggy. I also tried an example script that was available here in the forum:

Example 1: Properly Capitalizing First Name

#set ($fname = ${lead.FirstName})

#if($fname.equals(""))

Friend

#else

$display.capitalize($fname)

#end

This didn't work either.

Actions

598b656eb8fa8ed8030f6743a8e0699ca38309fb

@ Nicol Maurer on Jul 9, 2016 1:05 PM

Hi Nicol Maurer

Did you get this working?

I think your question was that the script you had placed not showing value in display. Did you actually try sending this email to a test lead?

Please let me know if you need help. There are a couple of gotcha's w.r.t. testing and debugging velocity scripts in Marketo.

Rajesh Talele

Actions

Robb Barrett

Jun 15, 2016 2:30 PM

You should also force it to lower case, then force it to title case, just in case someone enters an ALL CAPS NAME or a lower name oR SoMe weiRd MIX

#set ($lowername = $repfullname[0].toLowerCase())

#set ($propercase = $lowername.substring(0,1).toUpperCase())

Actions

Nicol Maurer @ Robb Barrett on Jun 16, 2016 8:41 AM

Thanks for your response. Good idea. Would the display tool work just the same?

Actions

Robb Barrett

@ Nicol Maurer on Jun 16, 2016 8:44 AM

Don't know. I actually never use Velocity.

Actions

9 Replies

Nicol Maurer Jun 15, 2016 9:24 AM
Mark Correct
Correct Answer
Right now I have:
#set ($name = ${lead.Salesperson})
#set ($repfullname = $name.split(" "))
$repfullname[0]

Returns: $repfullname[0]
Like • Show 0 Likes0
Actions
Jamie Lewis Jun 15, 2016 10:50 AM
Mark Correct
Correct Answer
Have you tried using the substring method? I think that will solve it.
Like • Show 0 Likes0
Actions
- Nicol Maurer @ Jamie Lewis on Jun 15, 2016 10:57 AM
  Mark Correct
  Correct Answer
  Thanks for your reply. I'm actually trying to get the {lead.Salesperson} value assigned to the $name variable. It's not currently assigning, or if it is, it's being assigned as an object and not a string.
  Like • Show 0 Likes0
  Actions
Jenna Molby Jun 15, 2016 2:21 PM
Mark Correct
Correct Answer
Your logic is correct. What displays in the email when you do a test send?
Like • Show 0 Likes0
Actions
- Nicol Maurer @ Jenna Molby on Jun 16, 2016 10:06 AM
  Mark Correct
  Correct Answer
  It just displays ' $repfullname[0]'.
  
  When I assign lead.SalesPerson to $name the value of $name isn't what is expected. It's blank. If I give lead.SalesPerson a default value it will display the default value. It seems a bit buggy. I also tried an example script that was available here in the forum:
  Example 1: Properly Capitalizing First Name
  #set ($fname = ${lead.FirstName})
  #if($fname.equals(""))
  Friend
  #else
  $display.capitalize($fname)
  #end
  This didn't work either.
  Like • Show 0 Likes0
  Actions
  - 598b656eb8fa8ed8030f6743a8e0699ca38309fb @ Nicol Maurer on Jul 9, 2016 1:05 PM
    Mark Correct
    Correct Answer
    Hi Nicol Maurer
    
    Did you get this working?
    I think your question was that the script you had placed not showing value in display. Did you actually try sending this email to a test lead?
    
    Please let me know if you need help. There are a couple of gotcha's w.r.t. testing and debugging velocity scripts in Marketo.
    
    Rajesh Talele
    Like • Show 0 Likes0
    Actions
Robb Barrett Jun 15, 2016 2:30 PM
Mark Correct
Correct Answer
You should also force it to lower case, then force it to title case, just in case someone enters an ALL CAPS NAME or a lower name oR SoMe weiRd MIX
#set ($lowername = $repfullname[0].toLowerCase())
#set ($propercase = $lowername.substring(0,1).toUpperCase())
Like • Show 0 Likes0
Actions
- Nicol Maurer @ Robb Barrett on Jun 16, 2016 8:41 AM
  Mark Correct
  Correct Answer
  Thanks for your response. Good idea. Would the display tool work just the same?
  Like • Show 0 Likes0
  Actions
  - Robb Barrett @ Nicol Maurer on Jun 16, 2016 8:44 AM
    Mark Correct
    Correct Answer
    Don't know. I actually never use Velocity.
    Like • Show 0 Likes0
    Actions

Splitting field data in token

Outcomes

Related Content

Recommended Content