Replace function for long text type data field | Community
Skip to main content
filipe23353816
filipe23353816
Level 2
January 3, 2024
Question

Replace function for long text type data field

  • January 3, 2024
  • 1 reply
  • 795 views

Hi,

The usual replace function only works on 255 character string fields correct? 

Is there another way to create a replace function for a long text type data field?

I want to replace "\n" with "<br>" for a longer text

 

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

1 reply

A
Anasso1337
Level 2
January 9, 2024

Hi @filipe23353816 

 

This is correct, you can't apply the replace function for a string over 255 chars in an enrichement activity.

One workaround solution is to use the export file activity upload to your ACS sftp and load the file again.

 

  1. Add a fork activity
  2. Use your replace function inside the export file activity in one transition (you might need to add your reconciliation key too to the exported file to link back the data from your original transition)
  3. Upload the file to your SFTP
  4. Download back you file and load it
  5. Reconcile your two transitions using a enrichement activity.

As you see this is quite the hassle, but this is the only workaround I found so far.

 

Hope this helps.

Terms & ConditionsAccessibility statement

Loading footer...