Skip to Content
0
Jun 15, 2015 at 02:16 PM

Is there escape parameter at input adapter?

19 Views

Dear Colleagues,

I use JMS_CSV_SERVER_Event_Input to subscribe to a data source.

ATTACH INPUT ADAPTER JMS_CSV_SERVER_Event_Input

TYPE toolkit_jms_csv_input

TO RawEventstream

PROPERTIES csvExpectStreamNameOpcode = FALSE ,

connectionFactory = 'ConnectionFactory' ,

jndiContextFactory = 'org.apache.activemq.jndi.ActiveMQInitialContextFactory' ,

jndiURL = 'tcp://localhost:61616' ,

destinationType = 'QUEUE' ,

destinationName = 'QueueName' ,

csvDelimiter = ',' ,

csvHasHeader = FALSE ,

scanDepth = 100 ;

With the default delimiter ',' we ran into problem when for example a description field which contains ‘,’ in its string.

We could think about choosing another delimiter. But, is there an escape parameter we could set at the ESP input adapter?

Thanks and best regards,

Tao