| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| TDS Delimiter duplication |
« View previous topic :: View next topic » |
| Author |
Message
|
| vinod_sri |
 Posted: Tue May 09, 2006 7:43 am Post subject: TDS Delimiter duplication |
 |
|
Apprentice
Joined: 10 Dec 2003
Posts: 42
Location: Atlanta
|
Hi,
I have a problem modeling the TDS message with ',' as delimiter. I specified the Delimiter Element Seperation as 'All Elements Delimited' and Delimiter as ','. This works fine as long as there is no ',' in the value of the element. For example, if the address element has a value like "18, lyman street" then the parsar treats the ',' as a delimiter and splits the address into two different values and the later is assigned to the next element. I have no clue how to handle this situation. This is something urgent. Can any of you please suggest me a way to handle this.
The message that I am handling is pasted here
00000250"20060424105042","BCN0097220","V5ZZ08575","BCN","ES","MES XXX","4E","XXX","XXXX","Import Invoice",268.81,268.81,"20050418","20050329","12700047131","TEXTIL AGB, SA",,"Cash",,,,,"C","PQ1","BCN","20050329","20050418",,,,"ES_NEW","C",,"50S","0506","PQ1"
You can find a ',' in the string "TEXTIL AGB, SA". Here the parser splits the text into two at the ','.
Thanks
Vinod. |
|
| 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
|
|
|
|
