ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TDS Delimiter duplication

Post new topic  Reply to topic
 TDS Delimiter duplication « View previous topic :: View next topic » 
Author Message
vinod_sri
PostPosted: Tue May 09, 2006 7:43 am    Post subject: TDS Delimiter duplication Reply with quote

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
View user's profile Send private message Send e-mail
jefflowrey
PostPosted: Tue May 09, 2006 7:57 am    Post subject: Reply with quote

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
View user's profile Send private message
kimbert
PostPosted: Tue May 09, 2006 8:39 am    Post subject: Reply with quote

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
View user's profile Send private message
sirsi
PostPosted: Tue May 09, 2006 12:28 pm    Post subject: Reply with quote

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
View user's profile Send private message
elvis_gn
PostPosted: Tue May 09, 2006 7:51 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
sirsi
PostPosted: Thu May 18, 2006 7:04 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » TDS Delimiter duplication
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.