| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Triiming Delimited Fields |
« View previous topic :: View next topic » |
| Author |
Message
|
| vk |
 Posted: Thu Oct 12, 2006 3:54 pm Post subject: Triiming Delimited Fields |
 |
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Hi,
I have a delimited message structure coming from the source application. To handle this, I have created a TDS message set with data element separation for the type as All Elements Delimited.
The design is working fine, but I had a question on how to trim the spaces that come at the end of some elements. The message format is as follows -
Field1,Field2 ,Field3,Field4 ,Field5
In the case of Fixed Width message sets, we can use the message set level property Trim Fix Len String to Trim Both or Trim Padding Characters to remove the extra spaces in the fields, when the message tree is created. But this is not working for delimited structures.
I am currently doing an explicit TRIM in the ESQL for all required fields. Is there a better way to handle this at the message set level?
Thanks,
VK. |
|
| Back to top |
|
 |
| kimbert |
| Posted: Fri Oct 13, 2006 12:38 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| I don't think there is a way to make the TDS format trim a delimited field. Looks like your current solution is the only option, at least for now. |
|
| 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
|
|
|
|
