Repeating fields Flat File Schema

, ,
1

Hi,

Does webMethods allow the fields in a record, in a flat file schema to be repetitive. We have the following flat file structure. Can any body please suggest how to go about making a schema for it.

Delimeters

  1. Record level, say, “;”
  2. Field level, say, “,”
  3. End of repeating field, say, “|”

What the last delimeter means is that some of the fields may repeat a variable number of times. And the presense of the delimeter 3 would signify the end.

This a typical flat file sample

RecordIdentifierField1,Field2,Field2,Field2|Field3,Field4;RecordIdentifierField1,Field2,Field2|Field3,Field4;

Appreciate your help.
Vikas.

2

I don’t think it is possible.
you have to define a field for each Field2. (This means that you should know maximum allowed number of instances of Field2)

3

I haven’t tried this but how about making the repeating field a record or composite record.
That might work.

HTH

4

When you are building composite or record you need to have the knowledge of their definition. You can set Max Repeat property of a record to unlimited, it will allow unlimited no. of records. However you cannot set max repeat property of a field or composite. Had wM allowed to do that it would have been possible to do what Vikas is asking.(it would be nice feature enhancement)