Text File with inconsistent data length
| 1111111111 | 2222222222 | ACT | $4444444.00 | no change | prop-55555 | contract matches | ||
| 33-33-33-333.333-333 | no change | tax typ x | ext trace matches |
I am running into an issue with building a model for a text report. In the table, green represents areas on the text reports that will consistently be there. Using the period for the dollar amount to grab that info, I am able to start to build a table with all the things in green. However, I need to grab the stuff in red. The problem is that there isn't always just one line for red. Sometimes there are 2 or three more lines of info I need. Is there a way to group all these into one column so as to keep one group of data in one row?
Answers
-
Hi Carter,
Is this for a Fiserv report? If so what report? We could have a template already prebuilt for this in our Monarch Model Library.
0 -
Try changing the End Field On Options in Advanced Options. Usually End of Left Justification works.
0 -
TurnerN3 said:
Try changing the End Field On Options in Advanced Options. Usually End of Left Justification works.
I’m waiting for Carter to tell me what report this is.
In the meantime, with a report like this you want to take the approach of using multiple templates.
Detail and Append Template
Or
Detail and Group Footer Template.
You will also want to use a floating trap for the field that’s not consistent.
Here are some videos you can watch to give you ideas…
0 -
Baba Majekodunmi_21731 said:
I’m waiting for Carter to tell me what report this is.
In the meantime, with a report like this you want to take the approach of using multiple templates.
Detail and Append Template
Or
Detail and Group Footer Template.
You will also want to use a floating trap for the field that’s not consistent.
Here are some videos you can watch to give you ideas…
This info is helpful. I believe that it is a fiserv report, but it is custom from DNA so I don't think there is anything pre built. I will attempt to use this information and solve my issue. Thanks!
0 -
Carter Hall said:
This info is helpful. I believe that it is a fiserv report, but it is custom from DNA so I don't think there is anything pre built. I will attempt to use this information and solve my issue. Thanks!
I’m about to update the page later today. We’ve added a few new templates for Fiserv systems including DNA. So we might have something for it.
While it maybe a custom report, I’m wondering if it isnt. Is there a report ID on the top left just above the “Bank” field of the report? What is that report ID?
0 -
Baba Majekodunmi_21731 said:
I’m about to update the page later today. We’ve added a few new templates for Fiserv systems including DNA. So we might have something for it.
While it maybe a custom report, I’m wondering if it isnt. Is there a report ID on the top left just above the “Bank” field of the report? What is that report ID?
No there isn't, the first line is the "BANK:" line
0 -
Another issue I am running into is that the lines in red aren't consistent. They have a couple different lengths of information I would want to grab.
0 -
Yes, sorry just below Bank is typically the report ID, like DP_CASH, MM_ACTV. Do you see it below BANK?Carter Hall said:No there isn't, the first line is the "BANK:" line
0 -
Baba Majekodunmi_21731 said:
Yes, sorry just below Bank is typically the report ID, like DP_CASH, MM_ACTV. Do you see it below BANK?
PS_LERETA_AUDIT
0 -
If you have a few minutes now I can look at it with you. I will send you an email.Carter Hall said:Another issue I am running into is that the lines in red aren't consistent. They have a couple different lengths of information I would want to grab.
0 -
Baba Majekodunmi_21731 said:
If you have a few minutes now I can look at it with you. I will send you an email.
Yes please
0 -
Could you use the red as the detail and append the green information?
0
Altair Employee