How skip a blank ligne in a detail mask?
Altair EmployeeHi 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
Answers
-
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.
0 -
Altair Forum User said:
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.
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)
0 -
Altair Forum User said:
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)
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
0
