| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Parsing |
« View previous topic :: View next topic » |
| Author |
Message
|
| eshwarttf |
 Posted: Tue Jul 05, 2011 2:56 am Post subject: Parsing |
 |
|
Novice
Joined: 12 Jan 2011
Posts: 11
|
Hi I have a txt document of data to be parsed into XML format , which contains data in table format say
EMPID SAL
1 22222
2 33333
3 44444
-followed by a line
total 99999. So the whole data is like
EMPID SAL
1 22222
2 33333
3 44444
total 99999
I have parsed the the empid and sal as repeating records using FIXED LENGTH, which has a group indicator 'EMPID SAL' . I have given 'total ' as terminator, so that remainin value is parsed as <total>.
What happens is , 'total ' is omiited and again 99999 is being parsed as EMPID and throws error as not enough data for SAL.
Should I have to use CHOICE or is there any other option? |
|
| Back to top |
|
 |
| kimbert |
| Posted: Tue Jul 05, 2011 5:16 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
You should
- set Data Element Separation to 'Tagged Fixed Length' on the outermost complex type
- Use tags, not Group Indicators. Move the Group Indicator values to the Tag field on the elements, and delete the Group Indicator values.
Give that a try, and let us know how you get on. |
|
| Back to top |
|
|
| eshwarttf |
| Posted: Wed Jul 06, 2011 3:26 am Post subject: |
|
|
Novice
Joined: 12 Jan 2011
Posts: 11
|
I solved it
anuyways Thnx buddy.. |
|
| 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
|
|
|
|
