1 Reply Latest reply: May 15, 2014 10:16 AM by Olly Bond RSS

    Problem trapping inconsistent multiple line data

      I have data that looks like the following and I am unable to uniquely trap the last line.I tried creating 3-4 group footer to capture the data then combine.But does not seem to work.

       

       

      Case 1:With all 8 fields.the / / in registered date is used as a trap.[/U]

      Real_ID_name.........................member_ID...............media..............registered_date

      username................................user_ID

      ..............................................Old_ID

      notification_description

       

      Case 2:No Old ID[/U]

      Real_ID_name.........................member_ID...............media..............registered_date

      username................................user_ID

      notification_description

       

      Case 3:No Old ID, user ID and username.[/U]

      Real_ID_name.........................member_ID...............media..............registered_date

      notification_description

       

      (The ...... are fixed spaces)

       

      In all these cases,it is possible that either one of the Real ID Name or member ID is empty.But media and registered date is mostly found present.

       

      Is it possible to trap these data using Monarch Pro 11?

       

      Thank you on any advice possible.

       

      From,

      Foong