How to create a comma-separated value file programmatically?
We are currently using PRPC 6.2.1 and have a business need to programmatically generate a comma-separated value file. This has to be done in an unattended fashion. Is there a way to do this apart from concatenating the data, quotation marks, and commas into a string prior to calling a Connect-File?
Posted: 4 years ago
Posted: 4 years ago
Whilst this is intended for User initiated, pxConvertResultsToCSV should provide a template for how to convert, prior to your Connect-File.
Posted: 4 years ago
We ended up using the StringBuffer-Append method to concatenate each line of data.
You can use Java's FileWriter API to create the CSV file programatically in your activity Java step before you invoke Connect-File.
FileWriter (Java Platform SE 7 )