MQSeries.net :: View topic - Message Set CSV and the quote (") character.

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Set CSV and the quote (") character.

Message Set CSV and the quote (") character.

« View previous topic :: View next topic »

Author

Message

NiceGuy

Posted: Mon Nov 08, 2010 5:36 pm Post subject: Message Set CSV and the quote (") character.

Apprentice

Joined: 11 Jun 2009
Posts: 37

Hi community,

I apologize if the title is not overly descriptive. I'm relatively
new to message broker so be gentle if my question is trivial.

I have built a message set for csv files that are haing problems
parsing one element in the message set in particular.

Here let me clarify with an example:

Code:

123456, 9876543, "EZ Clean 2.5" Blade", 567, 6676 ....

If you have not caught it let me clarify the element in
question is the "EZ Clean 2.5" Blade" in particular
the inch (") character.

I realize that the reason why the message set is failing is because this
element needs to be escaped.

Problem is the csv places these description fields in quotes because
the descriptions fields themselves can easily contain commas, the very
character used as a delimiter.

Regardless I was hoping someone had a solution so my message set could remove the extra " while stile preserving the quotes at the end like say ...

Code:

"EZ Clean 2.5 Blade"

Actually I am looking for any simple solution here .. it just seems
kind of lengthy to build a mechanism to parse these elements within
my code.

Is there nothing in the message set that can strip these
out from the string while getting parsed?

Of course I'm wait for the community suggestions
Thanks

kimbert

Posted: Tue Nov 09, 2010 1:03 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

This is the standard CSV quoting scheme. If you're on v6.1 or later you can use the CSV messaging standard for this. The message set property 'Quote character' will automatically default to the double-quote character when you select 'CSV' as the messaging standard.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Set CSV and the quote (") character.

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP