Trim http:// or https:// from field value. Via Velocity or other way...?

[hblifeguard2020]

Hi Community!

I am looking for a way to edit/trim a field value, removing the HTTP:// or HTTPS://   

Background: I am receiving a link from SFDC in a custom field on the contact object. I want to use this link as the main CTA in an email to the contacts, it is unique to each contact. But, as we all know when we use a token value as a link we must insert it without the HTTP//: or HTTPS:// and hard code the protocol into the email code, so Marketo will notice the protocol and properly wrap the link in tracking shortener.

How do I deal with this value having the http:// or https:// in it can I trim it with a velocity script? Is there an operational program I can rig up to trim the value? Unfortunately I cannot request that the value be modified at the source because other integrated systems and processes use the value as-is in SFDC.

Any wizard ideas out there?

Many thanks in advance.

Best,

Eric Rex

[SanfordWhiteman · Accepted solution]

Velocity can't make permanent changes to fields (so there could never be an operational trim-the-value campaign). It can do incredibly elegant/complex things with how fields display in an email, but the underlying value does not change.

But in this case, you shouldn't need a permanent change.

Simply have a Velocity script that outputs the entire anchor tag (including opening <a> and closing </a>) as that's how to properly output links from Velocity anyway:

#set( $fieldWithScheme = $lead.originalField)
#set( $fieldWithoutScheme = $fieldWithScheme.replaceAll("^https://","") )
<a href="https://${fieldWithoutScheme}">Click here</a>

[hblifeguard2020]

Thank you so much Sir!

You are right I just need to solve for the link in the email and not affect the field's stored value.  I really appreciate your help, this time an the 100 other times I have used your solutions. lol