Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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?

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Baba_Majekodunmi_703

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.

TurnerN3

Try changing the End Field On Options in Advanced Options. Usually End of Left Justification works.

Baba_Majekodunmi_703

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

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…

Understanding Report Design Templates
Exercise 4: from the Monarch Success Plan page.
Standard vs Floating Traps

Carter Hall

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…

Understanding Report Design Templates

Exercise 4: from the Monarch Success Plan page.

Standard vs Floating Traps

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!

Baba_Majekodunmi_703

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?

Carter Hall

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

Carter Hall

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.

Baba_Majekodunmi_703

No there isn't, the first line is the "BANK:" line

Yes, sorry just below Bank is typically the report ID, like DP_CASH, MM_ACTV. Do you see it below BANK?

Carter Hall

Yes, sorry just below Bank is typically the report ID, like DP_CASH, MM_ACTV. Do you see it below BANK?

PS_LERETA_AUDIT

Baba_Majekodunmi_703

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.

If you have a few minutes now I can look at it with you. I will send you an email.

Carter Hall

If you have a few minutes now I can look at it with you. I will send you an email.

Yes please

Matt G

Could you use the red as the detail and append the green information?