| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Fixed length field, variable length records |
« View previous topic :: View next topic » |
| Author |
Message
|
| Tonedef |
 Posted: Tue Mar 13, 2007 12:49 am Post subject: Fixed length field, variable length records |
 |
|
Apprentice
Joined: 05 Feb 2007
Posts: 44
|
I am trying to transform a a flat file of fixed length fields, but the last few fields are conditional making it variable length.
first I set the record type to Fixed Length, but after doing some reading this really is only for fixed length records, but the AL3 type seems to allow for what I want to do.
so I change the min/max to 0/1 at field level, select Acord AL3 as the record type, and set the delimiter as <CR><LF>
but it failed and appears to ignore the <CR><LF> and expect the remaining fields,
if I removed the fields from the type def, then the file worked, and I got the output I wanted, so for me it proves there is soething I still need to do to allow optional fields.
does anyone have any pointers please? |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Mar 13, 2007 4:18 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Acord AL3 should only be used for Acord AL3 data.
If you're trying to use delimited data, then you need to use TDS.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Mar 13, 2007 5:32 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| I would recommend that you change from 'Fixed Length' to 'Use Data Pattern'. Instead of setting the length=N on each element, set the data pattern to .{N}. |
|
| 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
|
|
|
|
