I have a multiline text field in a table field and as part of my workflow I want to copy it to another field but with the newlines removed. I was able to use the replace function to remove newlines from a character field but that isn't working for a field that comes from a table even if I copy it to a character field first.

The way that I was able to remove newlines from the character field with replace is by clicking on the "folded corner" icon next to the Value in an Active Link Set Fields action. Then I pressed enter after the double-quote and continued the replace on the next line. After closing, the edit window shows the newline as a vertical bar between the double-quotes and the replace would then remove the newlines from the character field - works great.

But it doesn't work with data that comes from a "sub-field" of a table even if I copy it to a regular character field first. I looked at the data from the database tables backing the main form and also the table field and it appears that in both cases the fields contain x'0A' as the newline so I don't understand why it would work in one case and not the other.

I've tried a bunch of strange things to remove the newlines like processing via a SQL statement or passing it to a local process but in even case the newlines play havoc. I suspect I'm missing the obvious. Remedy has been around for a long time - it can be that hard to remove some newlines!

Does anyone have experience with this type of problem?

Thanks!