Hi - I am in need of some help. I have searched through here for help and I have watched videos. I still can not seem to get my data mapper right. I am having trouble setting the boundaries. I am attaching my data mapper and sample data. I am trying to repeat on the plan number. Can someone please help me? The extraction I have set up is what I need it to look like. I just need it to repeat on the plan number.
WHSELoan_testFile.zip (7.1 KB)
So you want the whole text in a single record and do a repeat on the .Plan number keyword, regardless on the actual plan number (ex: 000015)?
As for instance, in your data, there is a plan number 000019 which occurs twice. Do you want this plan number on its own record?
No - I need one record per plan number.
Then simply choose Cut on number of lines = 50
EDIT: Set your bounderies to the following: See my later post instead.
YES!!! this works. Thank you so much!!
Sorry, I hadn’t seen the requirement that multiple plans with the same number should be part of the same record.
Still, this doesn’t require any scripting. Set your boundaries to the following:
Explanation
The Page Delimiter type is set to .Plan number....... as this text indicates the start of a new plan. However, the boundaries are then set to only create a new record when, upon encountering a new boundary, the plan number has changed (between column 24 and 31).
Whenever possible, use the native options in the DataMapper instead of using scripted boundaries because they are easier to manage and less error-prone. And they are slightly faster.
Just tried it and they both work!! Thank you so much!
You doubted it?!? 
