Partially purge data from a text field | Community
Skip to main content
Dan_Stevens_
Dan_Stevens_
Level 10
June 15, 2018
Question

Partially purge data from a text field

  • June 15, 2018
  • 1 reply
  • 931 views

We have a history field used to store web page activity, which is then displayed in our real-time alerts:

It’s a text field (not string) and looks like this in the Marketo:

Even though this is a text field, over time, this may reach its limit by active, known users on our website.  Any thoughts on how to go about partially purging old data – let’s say ‘older than 6 months’ – while leaving the rest of the data intact?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    June 15, 2018

    Only via webhook scripting engine, Dan.

    Parse as array of date + value pairs, filter, re-join as string, return string.

    Terms & ConditionsAccessibility statement

    Loading footer...