Velocity script to identify if the last character of the string is a period and remove it

5 replies
1009 views
Translate All

I have an existing lead field that contains the value for user Company Names, and with some company name ending in "Inc." we get an extra period at the end of the sentence where the token is placed.

I want to set up a script token that can identify if the last character in the lead field string is a period and remove it. I've looked into substring a bit, but haven't found a working solution.

Does anyone have any suggestions?

Marketo

SanfordWhitemanAccepted solution

User Group Leader

#set( $stripTrailingDot = $YourField.replaceAll("\.$","") )

SanfordWhiteman

Accepted solution

User Group Leader

#set( $stripTrailingDot = $YourField.replaceAll("\.$","") )

Translate

H

hcolemanAuthor

Level 2

Thank you for getting back to me. When I placed the code into the token, it returns the varibale as text. In the image below, I was testing our original token next to my new token to see how it renders, and as you can see I'm getting "$stripTrailingDot" as text.

I'm fairly new at using velocity script and don't know exactly how to properly display the value of the lead. The code is defined below.

#set( $stripTrailingDot = $lead.Company.replaceAll("\.$","") )
${stripTrailingDot}

Should I be referencing something other than $stripTrailingDot to get my lead.Company value to display?

Translate

SanfordWhiteman

User Group Leader

Do you have that field checked in the tree on the right-hand-side of Script Editor?

Translate

Sign up

Login with SSO

Login to the community

Login with SSO