Question

2
Replies
572
Views
VishalAswale850600954 Member since 2016 5 posts
Posted: August 19, 2015
Last activity: November 2, 2015
Closed
Solved

Need to read a fixed format structured file with multiple records

Hi,

I need to read a text file with 'n' records. I m using a file service which is parsing a structured rule.

The file service for structured parse type does  not allow me to add a record teminator. i get the following error when i try to add one "** you cannot choose a record Terminator if there are only Structured Parse Segments".
Due to this not able parse the next record in the file.

Eg. Records in the file:

1200012001Ram       Raju      9/09/2015 100050  

1200012002John      Jill      9/09/2015 100050

If i give the above records as below:

1200012001Ram       Raju      9/09/2015 1000501200012002John      Jill      9/09/2015 100050

it will read two records correctly, but i need to show this new record on new line.

Please let know how could we do this.

Thanks and regards,

Vishal A

Data Integration System Administration
Moderation Team has archived post
Share this page LinkedIn