| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Need to determine the datatype of XML tag contents. |
« View previous topic :: View next topic » |
| Author |
Message
|
| p25200 |
 Posted: Fri Sep 15, 2006 10:23 am Post subject: Need to determine the datatype of XML tag contents. |
 |
|
Newbie
Joined: 14 Jun 2004
Posts: 4
|
I have a block of XML data that I need to parse and trim (spaces). However, I can only trim those fields that are of a character (or blob) data type. So, if a given field is of the DATE, Integer, or any other numeric types, calling the trim function results in failure.
So, does anyone know if/how I can query the to-be-trimmed field beforehand, to make sure that it is a character field.
-Karl |
|
| Back to top |
|
 |
| kimbert |
| Posted: Fri Sep 15, 2006 12:29 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| You could always parse the data using MRM XML, which will populate the message tree with the correct data types. Depending on what you want to do, that may be enough, because the MRM parser automatically removes insignificant whitespace. |
|
| Back to top |
|
|
| p25200 |
| Posted: Fri Sep 15, 2006 12:37 pm Post subject: |
|
|
Newbie
Joined: 14 Jun 2004
Posts: 4
|
| Good suggestion. I'll give it a try (next week), and let you know. |
|
| 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
|
|
|
|
