Reltio Integration Hub

We have some data where it most likely originated from the mainframe many years ago. It has special characters (NUL - not null like no data as an example) that is causing our recipe to fail. We are looking to see if a recipe can remove the special characters. We can do this in a process outside of a recipe but want to see if it can be done within a recipe. Here is one example where you can see in an editor, the data just looks like blanks until you look in an editor-NULNULNUL...

Hi @Doug Yates,

You can please use transliterate function in formula mode to replace these. 
Here's is the document link for the same. https://docs.workato.com/formulas/string-formulas.html#transliterate

We have some data where it most likely originated from the mainframe many years ago. It has special characters (NUL - not null like no data as an example) that is causing our recipe to fail. We are looking to see if a recipe can remove the special characters. We can do this in a process outside of a recipe but want to see if it can be done within a recipe. Here is one example where you can see in an editor, the data just looks like blanks until you look in an editor-NULNULNUL...

We have some data where it most likely originated from the mainframe many years ago. It has special characters (NUL - not null like no data as an example) that is causing our recipe to fail. We are looking to see if a recipe can remove the special characters. We can do this in a process outside of a recipe but want to see if it can be done within a recipe. Here is one example where you can see in an editor, the data just looks like blanks until you look in an editor-NULNULNUL...