Bank Administration Institiute - Balance Reporting

[kashush]

I am trying to create a type tree that describes a very difficult format. Has anyone dealt with this format before?

The format uses comma field delimiters and forward slash segment terminations. There is a text field that may contain commas and forward slashes. No release character has been specified. I was able to get around this.

However, a there is a segment called the Continuation Segment. This segment may continue a text field. It starts with "88," and has no terminator and no fixed length. Currently the validation map sees the initiator and then goes to the end of the document, ignoring initiators of subsequent segments.

One collegue suggested using the initiator of next segments as the terminator. Would it be possible to use the same field as both an initiator and a terminator?

 

[eudius]

Hi,
I do not believe that you can because when Mercator sees the initiator of the next segment and validates it as a terminator to the previous segment, validation picks up with the next value after this initiaor/terminator. Can you use a pre-process card to loop through your continuation segment utilizing the next segments terminator as a terminator for the continuation segment. If you can do this you can use substitute, if you are pretty sure that the initiator value is not repeatable as a non-initiator. Substitute the initiator with a terminator concatenated with the initiator. Then pass the result to your next output card and use the new terminatro to identify the end of the continuation segment. Hope this helps, and even works.
Geo

 

[kashush]

What I did was use a preceding map that created terminators for each segment using the SUBSTITUTE function.