| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| TDS pipe symbol |
« View previous topic :: View next topic » |
| Author |
Message
|
| wmbsg |
 Posted: Tue Apr 20, 2010 2:51 am Post subject: TDS pipe symbol |
 |
|
Newbie
Joined: 20 Apr 2010
Posts: 2
|
Hi
I'm trying to transform a message from XMLNSC to csv file output format.
Output CSV file has to be in the below format
WMB|WMB|WMB|WB
Column delimiter is pipe symbol..
I have tried giving Delimiter as | and added pipe symbol to messageset Reserved Characters, but it didn't work out.
Any ideas? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue Apr 20, 2010 3:53 am Post subject: Re: TDS pipe symbol |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wmbsg wrote: |
| I have tried giving Delimiter as | and added pipe symbol to messageset Reserved Characters, but it didn't work out. |
What happened? Format not as you expected? If so, what did it look like? Was there an abend? An explosion? An elephant falling from the ceiling?
Or is the volcano in Iceland your fault??? 
Help us to help you. More information, better advice. Post any errors & some sample (presumably erronous) output.
Speaking generally, first action in any WMB problem is to take a user trace & see what's happening. Old advice oft repeated here but still good.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| wmbsg |
| Posted: Tue Apr 20, 2010 4:54 am Post subject: |
|
|
Newbie
Joined: 20 Apr 2010
Posts: 2
|
Sorry, for not posting all the details.
I'm getting output as given below
WMB,WMB,WMB,WB
Output is not showing with pipe symbol, but with commas
I tried using HL7, which worked fine, but I have to make this work with CSV messaging standard |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Apr 20, 2010 5:37 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Which delimiter did you change? At what level in the message set or message definition?
You may have to change the ',' in the presupplied samples in multiple locations. |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Apr 20, 2010 7:46 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Are you outputting a repeating field, or a sequence of different fields? If the former, have you set the Repeating Element Delimiter to the pipe symbol? |
|
| 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
|
|
|
|
