Truncated text fields after SET USING

[jclark58]

I currently filter incomming mail and populate my database using SET USING. which works fine.

We have noticed however that some multiline text fields have data missing when we go back and compare them to the incomming email. It appears some lines have been truncated where there is an end of line character possibly CR/LF or CR or LF.

As there is no way to stop users entering blank lines or starting new lines Is there a way we can alter the behaviour of SET USING to properly collect multiple line text fields with embedded newlines?

John

[aware_support]

Have you tried the REPLACE function to replace new lines with empty strings?

[jclark58]

Given that I dont have the contents of the email loaded into the database fields until after the SET USING, I have already lost the missing text.