Using the File BizComponent and writing a csv file, the bizcomp does not take into consideration commas within fields. This data should be quoted in the output file.
We had this logic in the old Excel bizcomp, but never in the FileBizComp. This support makes sense, but will need to be a feature request.
The work-around would be to use a functoid on fields that potentially have this problem, which would quote the data appropriately. It may also be possible to always quote all fields, for some applications.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=1930993
Originator: NO
We had this logic in the old Excel bizcomp, but never in the FileBizComp. This support makes sense, but will need to be a feature request.
The work-around would be to use a functoid on fields that potentially have this problem, which would quote the data appropriately. It may also be possible to always quote all fields, for some applications.