| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| TDS to XML - Delimiter in Quoted String |
« View previous topic :: View next topic » |
| Author |
Message
|
| migerrits |
 Posted: Wed Aug 30, 2006 10:08 am Post subject: TDS to XML - Delimiter in Quoted String |
 |
|
Apprentice
Joined: 13 Dec 2002
Posts: 35
Location: Canada
|
My input data is BLOB delimited by the "|" character and converts quite nicely on the broker from BLOB to TDS and XML formats. Well, most of the time it does.
Records are simple lines of the same layout on each line.
My pain comes here: I've found a few fields that contain the "|" character within a quoted string, where the field contents are underlined:
"abc|123"
The source application apparently does this because it doesn't like the "|" character either.
The Broker ignores the quotes ( " ) and splits this field into abc and 123 when it should stay as "abc|123".
I'm having trouble finding where in my Message Set that I need to change it in order to not ignore the quotes.
I am being given the data and cannot have this changed before it gets to me.
Thanks!
-mike |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Aug 30, 2006 10:31 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
This is a common problem with CSV models (comma separated values), where there are embedded delimiters that need to be ignored.
There are CSV samples that go over how to model this successfully in the v6 Samples Gallery.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| migerrits |
| Posted: Wed Aug 30, 2006 10:45 am Post subject: |
|
|
Apprentice
Joined: 13 Dec 2002
Posts: 35
Location: Canada
|
I'm using V5, by the way.
I've been hoping for a "clean" way of accomplishing this but haven't found it yet.
I have thought about replacing the unwanted pipe symbol with a space in my initial BLOB, since it's really just a free-form user description field. However, since the pipe symbol is also my field delimiter, this isn't a simple thing to try to do.
I have tried different options in my Message Set without much luck.
"Surely," thought I, "the Message Set can be made to understand that a quoted string means that you don't look inside it for any special characters?" I hope I'm not proved wrong. 
-mike |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Aug 30, 2006 12:57 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| The message broker team are aware that this is a common requirement, and they agree that it ought to be fixed. That's why the samples gallery shows how to work around the problem in v5/v6. |
|
| Back to top |
|
|
| migerrits |
| Posted: Thu Aug 31, 2006 8:01 am Post subject: |
|
|
Apprentice
Joined: 13 Dec 2002
Posts: 35
Location: Canada
|
Drat. I'll have to install the examples now. 
Thanks!
-mike |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
