Replace newline and special character in DM expression for Transaction matching

Summary:

We are currently loading data into Transaction Matching, and the data load process is completing successfully. However, upon reviewing the transactions within the reconciliation, we identified discrepancies and subsequently analyzed the data logs. The logs indicate that certain records are being rejected during the import process.

Upon investigation, we found that the issue is related to the Description column, which contains commas and newline characters. We were able to address the comma-related issue using a replacement expression; however, we have not been able to successfully remove or replace the newline characters.

The source file is in CSV format, and the newline characters are being introduced when users enter multi-line descriptions within a single Excel cell. These line breaks are being carried over into the CSV extract and are causing record rejections during the Transaction Matching data load.