# Delimited flat file schema problem

**URL:** <https://techcommunity.softwareag.com/t/delimited-flat-file-schema-problem/108778>\
**Category:** Forum\
**Tags:** EDI\
**Created:** [February 6, 2006, 6:16pm UTC](https://techcommunity.softwareag.com/t/delimited-flat-file-schema-problem/108778 "2006-02-06T18:16:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![vedantpatil](https://avatars.discourse-cdn.com/v4/letter/v/3da27b/32.png) [@vedantpatil](https://techcommunity.softwareag.com/u/vedantpatil)\
**Post date:** [February 6, 2006, 6:16pm UTC](https://techcommunity.softwareag.com/t/delimited-flat-file-schema-problem/108778/1 "2006-02-06T18:16:40Z")

</div>

I am new to webMethods, I am getting one problem while trying to prase the following file  
NEST2606.011,NEST  
1001,mum,10.00,20050626,07  
1002,mum,10.00,20050726,07  
2,20.00

Where first line is the Header part, other 2 lines are transaction part which may occure multiple times and last line is footer part.  
I have created the the schema accordingly accordingly with transaction records max repeat is unlimited. header and footer is 1.

In Flat File Definition → record parser, I have selected as Demiliter.  
Record: newline  
subfield: ,

But while test run, it gives me the following error  
com.wm.ui.UiException: com.wm.ff.parse.ParseException: [FFP.0012.0004]  
Found no valid records  
Could anyone please help me out here, I tried to search similar problems but could not get the solution.  
Thanks in advance  
Vedant

---

<div class="post-metadata">

**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\
**Post date:** [February 6, 2006, 8:29pm UTC](https://techcommunity.softwareag.com/t/delimited-flat-file-schema-problem/108778/2 "2006-02-06T20:29:22Z")

</div>

Did you choose nth field option?looks like your file is comma seperated file…  
So start the field1 as 0 and so on…  
What is ur RecordDefinition recordWithNoId?

HTH,  
RMG

---

<div class="post-metadata">

**Author:** ![vedantpatil](https://avatars.discourse-cdn.com/v4/letter/v/3da27b/32.png) [@vedantpatil](https://techcommunity.softwareag.com/u/vedantpatil)\
**Post date:** [February 7, 2006, 10:43am UTC](https://techcommunity.softwareag.com/t/delimited-flat-file-schema-problem/108778/3 "2006-02-07T10:43:08Z")

</div>

Yes, I have mentioned nth field. and field 1 from 0.I am using webMethods 6.0.1. I am not sure what is recorddefinition.

---

<div class="post-metadata">

**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\
**Post date:** [February 7, 2006, 8:06pm UTC](https://techcommunity.softwareag.com/t/delimited-flat-file-schema-problem/108778/4 "2006-02-07T20:06:35Z")

</div>

Basically you have to specify RecordDefinition (recordWithNoID)since your file dont have any starting record identifier to parse the file…so try this option and create field definitions (nth fields)under this record definition.

HTH,  
RMG

---

<div class="post-metadata">

**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/delimited-flat-file-schema-problem/108778/5 "2021-04-02T15:05:22Z")

</div>


