Scripting

When importing into CI_item through BOI I am getting LF/CR, I've resolved the extra LF/CR by cleansing the data on the way in. But the LF/CR is showing up in the itemcodedesc on CI_Item, which normally does not allows carriage returns. The extended description seems to be working fine however. When troubleshooting the issue is resolved by the system when a user edits the description in any way. Any thing I am missing on this?

Are you replacing all instances of the chr(13) and chr(10) in two separate Replace functions or combining it into one like Replace(sItemCodeDesc, Chr(13) & Chr(10), """")? Depending on the data, you might want to do it like this Replace(Replace(sItemCodeDesc, Chr(10), """"), Chr(13), """").