| Author |
Message
|
| teller121 |
 Posted: Fri Oct 27, 2006 11:58 am Post subject: Getting rid of extraneous delimiters in a output message |
 |
|
Newbie
Joined: 27 Oct 2006
Posts: 4
|
I have modelled a TDS message set. Input file is XML and output file is a ~ delimited text file. If my XML file coming in has 6 out of 10 tags that I need, I need to supress the extra ~ characters that are generated.
Example XML:
<ab>
<tag1></tag1>
<tag2></tag2>
<tag3></tag3>
<tag4></tag4>
<tag5></tag5>
<tag6></tag6>
</ab>
The XML that I receive might have only 6 of the 10 tags that I have defined in my message set. When the message goes out, I get extrat ~ delimiters in the message.
The OUTPUT might look like this:
12~ab~1234~1~2.1~2.33~~~~~~
Is there a way to supress these extra delimiters in ESQL?
thanks, |
|
| Back to top |
|
 |
| kimbert |
| Posted: Fri Oct 27, 2006 1:07 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| Is there a way to supress these extra delimiters in ESQL? |
I would try to do this in the message model before I tried to solve it using ESQL.
Which version of message broker are you using? There's a TDS property on complex types called 'Suppress Absent Element Delimiters'. It was added in one of the v5 CSDs, so it will be in v6 as well. |
|
| Back to top |
|
|
| teller121 |
| Posted: Wed Nov 01, 2006 8:55 am Post subject: changing in msg set worked...can this be done in ESQL |
|
|
Newbie
Joined: 27 Oct 2006
Posts: 4
|
| Thanks very much for the reply. I was able to change the message set and it worked. Is there a way to do this programatically in ESQL. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 01, 2006 9:35 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You don't have control over delimiters in ESQL - they're produced by the parser when it writes the bitstream.
You can control what fields are in the message tree, but that's it.
Or you can use the BLOB domain and adjust the delimiters after the message tree has been written to a bitstream.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Nov 01, 2006 1:41 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| Is there a way to do this programatically in ESQL |
I'm genuinely puzzled. Why would you want to? |
|
| Back to top |
|
|
|
|
