| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Generic CSV message set with empty fields |
« View previous topic :: View next topic » |
| Author |
Message
|
| Laurens |
 Posted: Thu Aug 29, 2013 2:22 am Post subject: Generic CSV message set with empty fields |
 |
|
Apprentice
Joined: 01 Oct 2009
Posts: 35
|
Dear Broker Experts ,
I have created a message set that has one field only that can occur 1 till -1 times. The reason of this message set being that I need to parse a CSV file and do not know beforehand how many columns the csv will have.
So when I parse the csv
A,B,C
I get perfectly
<Root>
<Field>A</Field>
<Field>B</Field>
<Field>C</Field>
</Root>
However , when I parse a CSV with a empty column
A,,C for instance ; I do not get an empty XML tag on it. I get.
<Root>
<Field>A</Field>
<Field>C</Field>
</Root>
I tried more or less everything with the NULL value settings but seem to have no luck in making it work.
By the way I use the same message set to have the oposite convertion (xml->csv) and that works fine.
Thus
<Root>
<Field>A</Field>
</Field>
<Field>C</Field>
</Root>
becomes A,,C in CSV
I gues this is a simple problem, but I'm missing it.
Any thoughts ?
Kindest regards
Laurens |
|
| Back to top |
|
 |
| kimbert |
| Posted: Thu Aug 29, 2013 2:29 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
|
| 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
|
|
|
|
