Picking up a very old thread:
efficient-method-to-create-csv-with-double-quotes
| Ibm |
remove preview |
 |
| webMethods |
| I was wondering if anyone have an efficient method of creating CSV from IS document that includes header names and the data wrap with double quotes. I suppose |
| View this on Ibm > |
|
|
if need is to use WmFlatFile and enclose every field with say quotes. One of the method suggested by Rob Eamon is to use formatting service.
It does add few inefficincies:
- Additional Service call for each field
- more operations / more memory utilization
- Formatting service are involved both for writing and reading
- if need is to strip "" during reading - it needs to be applied as QuotedRelease character
- using formatting service and quoted release at same time - doubles the quotes being generated - leading to need for having two Flatfile Schemas - one for read and one for write
Is there a better way of handling it?