3 Replies Latest reply: Oct 27, 2017 2:21 AM by Grant Perkins RSS

    How skip a blank ligne in a detail mask?

    Sylvain Goulet

      Hi all,

       

      I need to capture a block of data separated into differents fields but since Septembre a blank line appears in my reports.

      Is there an option to exclude blank lines in a detail mask ?

       

      Below an example of the txt file i receive:  (blank line before INFORMATION 2 block of data)

       

      *File since Septembe 2017

      - INFORMATIONS 1 <field1> <field2>

      ----------------

      <field3> <field4>

       

      - INFORMATIONS 2 <field5> <field6>

      ----------------

      <field7> <field8> <field9>

      <field10>

      - INFORMATIONS 3 <field11> <field12>

      ---------------

      <field13> <field14> <field15>

       

      *File before Septembre 2017

      - INFORMATIONS 1 <field1> <field2>

      ----------------

      <field3> <field4>

      - INFORMATIONS 2 <field5> <field6>

      ----------------

      <field7> <field8> <field9>

      <field10>

      - INFORMATIONS 3 <field11> <field12>

      ---------------

      <field13> <field14> <field15>

       

      Thank you for your help,

      Regards,

       

      Sylvain

        • Re: How skip a blank ligne in a detail mask?
          Chris Porthouse

          Are you trying to capture the field information in a multi-line detail template?  Probably the easiest way would be to edit the field and select the advanced tab:

          and modify the "Start Field On" properties to use either String or Preceding string.

            • Re: How skip a blank ligne in a detail mask?
              Sylvain Goulet

              Hi, thank you for your help.

               

              Yes I take multi-lines detail mask because i need to capture all the fields in the 3 INFORMATION blocks in a single report line (all fields from <field1> to <fields15> on the same line).

               

              I have tried the advanced properties for the fields but its a bit complicated as the contents of the fields are variables. (only INFORMATIONS is always here)

                • Re: How skip a blank ligne in a detail mask?
                  Grant Perkins

                  Hi Sylvain,

                   

                  Is this a basic text file you are working with or an extraction from a PDF(or something similar)?

                   

                  If you have a working model for versions of the report before Septembre AND if the only difference is the the blank line one option might be to pre-process the text file to remove blank lines.

                   

                  If you are using the model once a week or once a day it does not add much time to the process. If you work with a hundred files a day it may not be such a good approach unless you have Automation available.

                   

                  Alternatively, if your fields are all NAMED in the file - usually seen in the style

                   

                  FIELD NAME:   data for the field      FIELD NAME 2:  data for the field

                   

                  Then you might be able to adopt the "Preceding  String" option to pick out the fields independent of the line on which they appear in the record. However they need to be in a consistent position horizontally in the report.

                   

                  The third option, which would make the model somewhat adaptable should any future versions of the report introduce additional differences, would be to capture all of the report rows as blocks (or a single block) of text and then process the extracted data into the fields you require using calculated fields.

                   

                  I am assuming here that you are using Monarch Classic rather than Data Prep Studio for your processing. It might be useful to know which version you have.

                   

                  I suppose there is also the question of where the blank line came from.

                   

                  With a basic text file it might be something as simple as a line wrapping due to a change of report width somewhere during formatting. I assume you have already eliminated that possibility?

                   

                  Does any of this help at all?

                   

                   

                  Grant