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 » Parsing Text to CSV within ESQL

Post new topic  Reply to topic Goto page Previous  1, 2
 Parsing Text to CSV within ESQL « View previous topic :: View next topic » 
Author Message
kimbert
PostPosted: Wed Feb 29, 2012 3:47 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Glad you were able to solve it. Did the user trace help you to find the problem?
Back to top
View user's profile Send private message
jacquesvdm
PostPosted: Wed Feb 29, 2012 9:38 am    Post subject: Reply with quote

Apprentice

Joined: 18 Jan 2012
Posts: 29

It actually did help, as I saw the values been matched which were slightly different than the data pattern. The matching pattern for example for an event type 3 would have been ''3'' as displayed within the user trace where in fact it should find ''"3"",". This includes a comma to indicate the end of the my tag. It is actually very powerful and allows me to perform transformation of this CSV file to any format I want with virtually zero coding. Speed of this transformation is not that important as I collect statistical data.
This was the first time I had a need for the user trace hence my inexperience with it. I will use it again, so thanks for the awareness.
Back to top
View user's profile Send private message
kimbert
PostPosted: Wed Feb 29, 2012 10:41 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Quote:
This was the first time I had a need for the user trace
More likely, you needed it before but did not realize it! User trace is useful for debugging all kinds of message flow problems and I think you have been a WMB user for a few years now.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Parsing Text to CSV within ESQL
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.