aswale (VishalAswale850600954)

VishalAswale850600954 Member since 2016 5 posts
Posted: August 19, 2015
Last activity: November 2, 2015
Posted: 19 Aug 2015 8:00 EDT
Last activity: 2 Nov 2015 12:16 EST

Need to read a fixed format structured file with multiple records


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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.