I want to use a comma as a delimiter. Some of the fields already have a comma character in them. File Adapter does not seem to be able to deal with this. How can I solve this problem?

I want to use a comma as a delimiter. Some of the fields already have a comma character in them. File Adapter does not seem to be able to deal with this. How can I solve this problem?

book

Article ID: KB0084932

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Files for Unix and Windows -
Not Applicable -

Description

Resolution:
You cannot use the comma character as the delimiter if the fields in your file contain the comma character. You need to analyze your input files and determine the printer-able special characters that are never used. You then need to select one of those characters as your delimiter.

Issue/Introduction

I want to use a comma as a delimiter. Some of the fields already have a comma character in them. File Adapter does not seem to be able to deal with this. How can I solve this problem?