How to Remove “https” From a URL and Update a New Field

[ashah123]

Hi Team,

We have a field in Marketo that comes from our CRM ( Dynamics 365 ) , and it contains a full URL (MS Bookings link). We currently use it via the lead token in our emails, and the link works, but it doesn’t get tracked because the token URL includes “https”.

To address this, we're exploring the option of creating a new field and running a daily smart campaign to copy the value from the old field—but without the “https://” prefix and update it to the new one, so it can be tracked

Example:
Old field value: https://www.google.com
New field value: www.google.com

The idea is to update the new field using the old field’s value, removing the protocol. However, I’m unsure whether the Change Data Value flow step can handle this type of string transformation directly.

Could you advise on possible approaches to remove “https://” when updating the new field?

Any guidance on handling this scenario would be helpful.

Please let me know if you need anything else.

Regards,

Akshat

[Michael_Florin]

Here's a thread where this issue was discussed:

https://nation.marketo.com/t5/product-discussions/trim-http-or-https-from-field-value-via-velocity-o...

[SanfordWhiteman]

You don't need a new field. Use Velocity – there was a thread discussing this exact topic on the past week.

Permanently altering the field isn't possible using Velocity, nor with Change Data Value. You need a webhook-compatible service to do that.