Flat File record delimiter

, ,
1

I am trying to build a flat file that looks like this:

A21G 97848000000001 Willem
A21F 97848000000001 Rosiers
A21G 97848000000002 Jessica
A21F 97848000000002 Herron
A21G 97848000000003 Dave
A21F 97848000000003 Preston

Each line is a composite of three fields (Code, Employee Num, and Name) The first line is a First Name, the Second is a last name. This example has 2 employee records, 1 for Willem, 1 for Jessica and 1 for Dave. I have the following problem. I need each composite/field on its own line but I also need the records to be separate too… therefore I am having a hard time finding the correct record delimiter to use. If I use a ‘!’ and use the following sample file, it works fine.

A21G 97848000000001 Willem
A21F 97848000000001 Rosiers
!A21G 97848000000002 Jessica
A21F 97848000000002 Herron
!A21G 97848000000004 David
A21F 97848000000004 Preston

My schema has the following settings:
Record Parser: Delimiter
Record Character:!
Composite Character: newline
Subfield: <empty>
Record Identifier: starts at position 0
First Name composite extractor: field 0
Last Name composite extractor: field 1

Any help anyone could give would be GREATLY appreciated!

Thanks,
Jessica

2

Jessica,

I had a similar problem and i solved it this way,my file looks like this

9200081020040
9210081020040
9200081020041
9210081020042
9200081020043
9210081020043

the first field is RecordId and next OrderNo

So to read this i created a flatfile schema
920(unlimited)
|
field defs
|
–>921(rec def)(unlimited)
|
fld defs

make sure the second record comes as a sub record (inside) of the first Record

Record Parser: Delimiter
Record character : newLine
Record Identifier: starts at position 0

Also there is a packagecalled wmEDISamples which comes along with EDI Package and has good examples. If you can go thru it,i am sure that will solve your problem

3

Kamal,

Thanks for your help-- that seemed to work out for me. I created a root record called A20G, with child records A20F… etc. So the field delimiter is newline… and it recognizes the new record when it hits A21G. We also restricted the child record (A21F) to max occurrence = ‘1’ but the root record (A21G) is max occurrence = ‘Unlimited’

A21G 97848000000001 Willem
A21F 97848000000001 Rosiers
A21G 97848000000002 Jessica
A21F 97848000000002 Herron

Thanks!
Jess

4

Hi
I’m trying to build a flat file template (fixed) with no segment-id.
we have webM 4.0.1 with WmEdi package. The template is defined as follows…
<segment-delimiter> (from WmEdi Doc,page97)
<keyword></keyword>
<offset></offset>
<fixed>10</fixed> (file records are seperated by new line)
</segment-delimiter>

<segment>
<POSITION NAME=“IA” START=“0” LENGTH=“8”/ >
<POSITION NAME=“IB” START=“9” LENGTH="16/ >
</segment>
File content:
77749930 GRC P0032DODD3938S 965G709

Can anyone help me on this, TIA
Uday Nand

5

the segment name needs to be recordWithNoID.

This is how it’s done in later version of wm. I have not worked with 4.0.1.
Search the group for recordWithNoID and you will find some more info.
HTH

6

Opps, I could have done search on the keyword “recordWithNoID” before posting. I tried with edi template,flat template etc., any how I found the solution at the following url
[url=“wmusers.com”]wmusers.com

Thanks Chris…

Cheers
Uday Nand