Hello everyone,
I've encountered a requirement involving the export of a text file from an export scenario.
While I've been successful in exporting the text file, an issue arises where an empty line is appended to the file at the end of the data, which I'm seeking to eliminate.
I've attempted to use the Trim function, but regrettably, I haven't achieved the desired outcome. I came across a forum discussing a similar scenario, where they addressed the problem using the ACH provider and its BlockSize parameter to remove empty lines from ACH data. However, I've encountered a hurdle in applying the BlockSize parameter to the CSV data provider.
For more information, you can refer to this forum thread:https://stackoverflow.com/questions/49339994/flat-file-export-in-acumatica-creates-space-lines-in-the-file
I'm grateful for any assistance.
Thank you,