Expand my Community achievements bar.

Replace function for long text type data field

Avatar

Level 3

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

 

1 Reply

Avatar

Level 2

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.