# Flat File Content

**URL:** <https://techcommunity.softwareag.com/t/flat-file-content/107731>\
**Category:** Forum\
**Tags:** EDI\
**Created:** [February 13, 2003, 3:45pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731 "2003-02-13T15:45:21Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Frank\_Olsen](https://avatars.discourse-cdn.com/v4/letter/f/f05b48/32.png) [@Frank\_Olsen](https://techcommunity.softwareag.com/u/Frank_Olsen)\
**Post date:** [February 4, 2004, 12:09am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/21 "2004-02-04T00:09:13Z")

</div>

To Mr. Carlson,

I’ve got a very silly question at this point: where are the tutorials? On Advantage I only found tutorials for version 4.6. Are they in the User’s Guide?

Best regards,

Frank Olsen

---

<div class="post-metadata">

**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 4, 2004, 12:33am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/22 "2004-02-04T00:33:19Z")

</div>

They hold some valuable predefined examples/flows/documentation (usersguide pdf’s).

HTH.

---

<div class="post-metadata">

**Author:** ![wMusers.Com1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/wmusers.com1/32/170_2.png) [@wMusers.Com1](https://techcommunity.softwareag.com/u/wMusers.Com1)\
**Post date:** [February 4, 2004, 12:39am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/23 "2004-02-04T00:39:05Z")

</div>

Go to the home page of the WmFlatFileSamples package. If you have IS installed on your local workstation that would be:

[http://localhost:5555/WmFlatFileSamples/](http://localhost:5555/WmFlatFileSamples/)

HTH,

Mark

---

<div class="post-metadata">

**Author:** ![gdpani](https://avatars.discourse-cdn.com/v4/letter/g/a9a28c/32.png) [@gdpani](https://techcommunity.softwareag.com/u/gdpani)\
**Post date:** [March 16, 2004, 9:07pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/24 "2004-03-16T21:07:10Z")

</div>

I am trying to parse the mainframe punch file which is of fixed length of 400 characters. I have created the flatfile Dictionary and schema. I am using the schema to parse the flatfile which contains the multiple records each of length 400 characters. while parseing using the Test tab on the Flatfile Editor from the developer, I am able to get only the first record parsed successfully. All the remaining records are not parsed and I get the “recordWithNoID” for the number of records in the flatfile.

Could you please tell me how can I solve this problem.

Thanks

---

<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:** [March 16, 2004, 9:37pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/25 "2004-03-16T21:37:57Z")

</div>

Dhandapani,

Make sure in the flatfile Dictionary/Schema if “recordWithNoID” record definition under properties max Repeat set to “unlimited” or 1.  
Set this option to “unlimited” for parsing multiple records.

And also check the Flatfile Definitions settings like (Record Delimiter (newline or carriagereturn or tab)depends on your sample mainframe flatfile.

HTH.

---

<div class="post-metadata">

**Author:** ![gdpani](https://avatars.discourse-cdn.com/v4/letter/g/a9a28c/32.png) [@gdpani](https://techcommunity.softwareag.com/u/gdpani)\
**Post date:** [March 16, 2004, 10:14pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/26 "2004-03-16T22:14:53Z")

</div>

RMG,

I have not defined any record for the “recordWithNoID” in the dictionary/schema because all my records have a record identifier at position 0, the first 3 characters are record identifier in my flatfile.  
I am using the mainframe punch or fixed length file for which I don’t know what would be the record delimiter.

I tried using the newline and carriage return for the release character option in the definition tab, but still I am getting the recordWithNoID with no data in it. For me it seems its not recognizing the record idtnetifier in position 0 of the record.

All my records have “unlimited” option set for the Max Repeat property except the Header record which I am able to extract.

I am using the webMethods 6.0.1

Thanks

---

<div class="post-metadata">

**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 19, 2004, 7:48am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/27 "2004-03-19T07:48:57Z")

</div>

You may have a record delimiter issue. You need to view a copy of the file on you wm server in some sort of a hex editor. On windows you can use debug or the UltraEdit text editor. If you’re on UNIX find the equivalent.

HTH

---

<div class="post-metadata">

**Author:** ![gdpani](https://avatars.discourse-cdn.com/v4/letter/g/a9a28c/32.png) [@gdpani](https://techcommunity.softwareag.com/u/gdpani)\
**Post date:** [March 19, 2004, 9:48pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/28 "2004-03-19T21:48:41Z")

</div>

Chris,

Thank you, using Ultraedit I was able to figure out the problem.

---

<div class="post-metadata">

**Author:** ![a\_rajasekhar](https://avatars.discourse-cdn.com/v4/letter/a/bc8723/32.png) [@a\_rajasekhar](https://techcommunity.softwareag.com/u/a_rajasekhar)\
**Post date:** [May 26, 2004, 11:24am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/29 "2004-05-26T11:24:29Z")

</div>

Hi,  
Currently I am working on a flatfile schema. It contains 3 record types. It can contain one header record, one trailer record and multiple details records. I have a field in trailer record called total count, which should display the total number of records( i.e. 1 header+ no. of detail + 1 trailer). Is there any logic to count no. of details records at runtime in a flatfile? Plz. send reply… Thank you…

From,  
Raja sekhar.

---

<div class="post-metadata">

**Author:** ![Kalyan3](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/kalyan3/32/247_2.png) [@Kalyan3](https://techcommunity.softwareag.com/u/Kalyan3)\
**Post date:** [May 26, 2004, 11:59am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/30 "2004-05-26T11:59:37Z")

</div>

Raj Shekar,

When creating either a Record Definition or Record Refernce in FlatFile schema there is a property called Check Fields. Set this to True and check. A variable called segmentCount will be added to that Record which gives the count.

Regards,  
Kalyan

---

<div class="post-metadata">

**Author:** ![a\_rajasekhar](https://avatars.discourse-cdn.com/v4/letter/a/bc8723/32.png) [@a\_rajasekhar](https://techcommunity.softwareag.com/u/a_rajasekhar)\
**Post date:** [May 26, 2004, 2:57pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/31 "2004-05-26T14:57:16Z")

</div>

Hi Kalyan,  
Thanx for the Help…

---

<div class="post-metadata">

**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:** [May 27, 2004, 1:58am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/32 "2004-05-27T01:58:36Z")

</div>

Has anyone tackled the issue of reading in a flat file with a multiple character record delimiter? I need to delimit my records based up opon three alpha characters, and I do not believe that the wMFlatFile adapter will allow for this.

Regards

---

<div class="post-metadata">

**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:** [May 27, 2004, 6:20pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/33 "2004-05-27T18:20:27Z")

</div>

If you’re using 6.X you can specify the delimiters on the Flat File Definition tab when creating the schema.

---

<div class="post-metadata">

**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:** [May 27, 2004, 10:51pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/34 "2004-05-27T22:51:18Z")

</div>

Chris, I have pretty extensive knowledge of the 6.X platform including the wMFlatFile package, delimited and fixed length parsing. However, I have a specific question regarding multiple character record delimiters in a delimited file.

example data:

M00103|01|R|1991|END K01023|52| |2000|END M00099|03| |1|END END\_OF\_DATA

There are three records in the string. Fields are pipe delimited. Records are 'END ’ delimited. The end of file is recognized by the string END\_OF\_DATA.

Unfortunately, as far as I can tell, in the flat file schema it will not allow a user to enter more than one character for a record delimiter.

Thank you

---

<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:** [May 27, 2004, 11:21pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/35 "2004-05-27T23:21:20Z")

</div>

I believe there is no way of handling multiple Record Identifiers using the FlatFile Schema editor.

Regards,

---

<div class="post-metadata">

**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:** [May 27, 2004, 11:46pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/36 "2004-05-27T23:46:23Z")

</div>

BE77,

You can enter more than one character as the record delimiter but it only seems to pick up the first character. Maybe that’s a bug.  
If it allows the entry then in theory it should process it. I would take it to Tech support.

Let us know the result.

---

<div class="post-metadata">

**Author:** ![raymoser](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/raymoser/32/694_2.png) [@raymoser](https://techcommunity.softwareag.com/u/raymoser)\
**Post date:** [May 28, 2004, 12:11am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/37 "2004-05-28T00:11:32Z")

</div>

BE77,

I would parse the file the old fashion way without using the FF adapter since it is not as flexible as needed.

You could look at it like this: If the END\_OF\_DATA string is present, then you know for processing sake that the file is whole (not partially written). If this is the case, then you should be able to pass the string into the string tokenizer and use the '|END ’ as a delimiter (or something close to this.

It will yield a string array of your individually pipe-delimited records. Then, you can call a child flow that breaks the string record apart into an IData record containing the fields, passing in one record at a time, receiving the IData single record that can be appended to a Document List. There are more optimized methods of coding, but this will get you to a point where you can process records.

Does this make sense??

HTH

Ray

---

<div class="post-metadata">

**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:** [May 28, 2004, 2:07am UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/38 "2004-05-28T02:07:58Z")

</div>

Thank you all for your support and suggestions. I appreciate it. I will probably just continue on as I started after running into this issue and use the replace flow to add a file delimiter (carriage return)after each 'END ’ and use the 'END ’ as the record ID. This simplifies the process quite a bit and allows me to use the FF parser to convert the files and perform validations.

Thank you though. If anyone hears of a method to map multiple characters into a delimiter, or, as RMG mentioned, to call multiple document identifiers for multiple records within a file, please email me.

[groove81@juno.com](mailto:groove81@juno.com)

REGARDS

---

<div class="post-metadata">

**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:** [May 9, 2005, 6:51pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/39 "2005-05-09T18:51:07Z")

</div>

Hi, I have a Flat File Schema like as follows.

Record delimeter: !  
Field Delimeter: \*

And the Flat file Structure is:

Header

- AuthorizationCode
- Deptno

I am passing the flat file(text file) while running the Flat file Schema.  
The contetns of the Text file is:  
Header_100_100!Header_200_100!

But i am getting errors like “[FFP.0011.0012] Unexpected element” in the error position: 2. and “isValid” is False.

If i try to give only one record as the input,that is Header_100_100!, it works fine. and “isValid” is True.

Can any body help me on this. Thanks

---

<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:** [May 9, 2005, 7:16pm UTC](https://techcommunity.softwareag.com/t/flat-file-content/107731/40 "2005-05-09T19:16:25Z")

</div>

What is your RecordDefinition set to? and make sure the maxRepeat set to unlimited if there are multiple records in the flatfile.

HTH,  
RMG

[Previous page](https://techcommunity.softwareag.com/t/flat-file-content/107731.md?page=1)

[Next page](https://techcommunity.softwareag.com/t/flat-file-content/107731.md?page=3)
