# Flat File record delimiter **URL:** \ **Category:** Forum\ **Tags:** EDI\ **Created:** [February 9, 2004, 8:08pm UTC](https://techcommunity.softwareag.com/t/flat-file-record-delimiter/108146 "2004-02-09T20:08:52Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jessica\_herron.10363](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@jessica\_herron.10363](https://techcommunity.softwareag.com/u/jessica_herron.10363)\ **Post date:** [February 9, 2004, 8:08pm UTC](https://techcommunity.softwareag.com/t/flat-file-record-delimiter/108146/1 "2004-02-09T20:08:52Z")
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: \ 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 ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [February 10, 2004, 3:12am UTC](https://techcommunity.softwareag.com/t/flat-file-record-delimiter/108146/2 "2004-02-10T03:12:16Z")
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 ---
**Author:** ![jessica\_herron.10363](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@jessica\_herron.10363](https://techcommunity.softwareag.com/u/jessica_herron.10363)\ **Post date:** [February 11, 2004, 9:48pm UTC](https://techcommunity.softwareag.com/t/flat-file-record-delimiter/108146/3 "2004-02-11T21:48:30Z")
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 ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [March 4, 2004, 4:16am UTC](https://techcommunity.softwareag.com/t/flat-file-record-delimiter/108146/4 "2004-03-04T04:16:46Z")
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… \ (from WmEdi Doc,page97) \\ \\ \10\ (file records are seperated by new line) \ \ \ \ **Author:** ![Chris\_L](https://avatars.discourse-cdn.com/v4/letter/c/ba9def/32.png) [@Chris\_L](https://techcommunity.softwareag.com/u/Chris_L)\ **Post date:** [March 4, 2004, 6:53am UTC](https://techcommunity.softwareag.com/t/flat-file-record-delimiter/108146/5 "2004-03-04T06:53:22Z") 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 ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [March 4, 2004, 10:28pm UTC](https://techcommunity.softwareag.com/t/flat-file-record-delimiter/108146/6 "2004-03-04T22:28:04Z")
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](http://www.wmusers.com/wmusers/messages/117/15311.shtml)”][wmusers.com](http://www.wmusers.com/wmusers/messages/117/15311.shtml%5B/url%5D) Thanks Chris… Cheers Uday Nand ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 3:05pm UTC](https://techcommunity.softwareag.com/t/flat-file-record-delimiter/108146/7 "2021-04-02T15:05:05Z")