| |
|
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 |
|
 |
| jefflowrey |
| Posted: Tue May 09, 2006 7:57 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There were some database issues just a few minutes ago, so it's probably not your fault that you triple-posted.
Please go through and delete the other two copies of this question.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue May 09, 2006 8:39 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Good problem description - thanks for that. This is a fairly common requirement. If you are using v6 you will find the solution in the CSV samples ( Sample Message CSV_5 and Sample Message CSV_6 ). If you're not on v6, just let me know and I'll post the solution. |
|
| Back to top |
|
|
| sirsi |
| Posted: Tue May 09, 2006 12:28 pm Post subject: |
|
|
Disciple
Joined: 11 Mar 2005
Posts: 177
|
| i remeber myself facing this ( in v2.1)....used data pattern to parse the message... is their any other way... |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue May 09, 2006 7:51 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi vinod_sri,
A simpler solution (if you can have a small design change) is:
Either you got to ask the sender of the message to remove the ',' or ask him to replace it by another character, say '#' and then later in a compute, replace the '#' by ','.
Regards. |
|
| Back to top |
|
|
| sirsi |
| Posted: Thu May 18, 2006 7:04 am Post subject: |
|
|
Disciple
Joined: 11 Mar 2005
Posts: 177
|
but if the client is adamant you cant do anything  thats the case with me always |
|
| 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
|
|
|
|
