We need to generate a pipe delimited text file from data available in My SQL. We

We need to generate a pipe delimited text file from data available in My SQL. We are trying the following solutions: Have a view in MySQL, query data to process in Appian, use generate file from template doc smart service to generate file. Total Data is around 4MB as of now. The query fails if we query more than 500 records otherwise this solution works.

1. Can I append to a text file? If yes, then we can create a loop based process to query and append to the text file.
2. Do we have an option (like smart service) similar to Database Table to CSV. As I found this service works fine with 4MB of data. As we have pipes (|) in our views, the DB Table to CSV creates a file having " " to the data in single column we have in the view. Alternatevly is it possible to remove the char - ".
We are open to other possible solution. Thanks in advance for your help....

OriginalPostID-92429

OriginalPostID-92429