Max Lines and Characters

[f_cruz]

Got it. Thanks again.

[f_cruz]

Is there a way select those records or marked them so I can print a report?

[f_cruz]

Do I need to run this code for each line? I see it is only looking at line1. Can I have it look at all lines (lines1 through 10)?

[Ronald Anusiewicz]

Fernando,

I do not know how many records we are talking about. Hundreds, thousands, 10 thousands?

I understand about counting the lines. It seems to me you will have many records with the maximum lines available. Not sure how you will be able to determine a single largest.

Looking at your example, I can’t figure out how you came up with 40 characters. Are you eliminating spaces? Are you adding multiple lines together? If so, which ones?

Using .field_statistics, from the help file:
The <TBL>.FIELD_STATISTICS() method computes statistics (first value, last value, minimum value, count, total, average, standard deviation and variance) for Expression, for all of the currently selected records in the table referenced by <TBL>.

The function will return the “Maximum”, but the function will not tell you which record.

With the information have posted, I’m thinking that I would:

1. create a temporary table with at least 2 calculated fields to store the number of lines and count the characters for each record
2. the temp table would contain the fields need to give the results you are looking for.
3. example: line 1, line 3, line 4, line 5, line 6, line 7, line 8, line 9, line 10, record number or a unique value of some sort, calc->field_line, calc->field_chars
4. create a script that would step through the sample table writing the contents of the fields you want to the temp table
5. create a report for the temp table filtered to show the results you are looking for
6. example: cal->field_lines = 5 .and. cal->field_chars = 40

I'm sure there are other ways to do this, but I would try this approach myself.

[f_cruz]

Hello Ronald,

Thanks for the info and sorry for my delayed response. I have returned to this project to see if I can make some headway.

To answer your questions above, our list quantities will vary. Customer mailings will vary anywhere between 1 record to 100,000's of records. And in my example below, I got the maximum number of characters 40 because LINE 8 = "1234567 Any Street, Bldg 456, Ste 987654"

For example: Maximum number of lines required is 5 SEE RECORD # 1 Maximum number of characters required is 40 SEE RECORD # 672 REC#: 1 maximum _LINES LINE1 P1 T1********AUTO**MIXED AADC 07099 LINE2 # LINE3 John Doe LINE4 ABC Company LINE5 LINE6 LINE7 LINE8 123 Any Street LINE9 Anytown, US 12345-6789 LINE10 LINE11 0027012345611460000103079308231 LINE12 00001 _______________________________________________________________________________________ REC#: 672 maximum CHARS LINE1 P1 T1********AUTO**MIXED AADC 07099 LINE2 # LINE3 Jane Doe LINE4 LINE5 LINE6 LINE7 LINE8 1234567 Any Street, Bldg 456, Ste 987654 LINE9 Anytown, US 12345-6789 LINE10 LINE11 0027012345611460000103079308231 LINE12 00672

Thanks again for your input!

[f_cruz]

Hello all,

Thank you all for your input. I have my report up and running. May not be the conventional way to do it but the results are what I was looking for.

Is there a way to split a table into multiple tables based on a field? For example: I have a table(,dbf) of 1,000 records. In the table there is a field named "Segment" which has 1, 2, 3, or 4. How can I split this into 4 separate tables?

Thanks!

[Al Buchholz]

Hello all,

Thank you all for your input. I have my report up and running. May not be the conventional way to do it but the results are what I was looking for.

Is there a way to split a table into multiple tables based on a field? For example: I have a table(,dbf) of 1,000 records. In the table there is a field named "Segment" which has 1, 2, 3, or 4. How can I split this into 4 separate tables?

Thanks!

build a copy operation and filter on the segment value.

[f_cruz]

Will I need to build a separate copy operation for each segment?

[Al Buchholz]

Will I need to build a separate copy operation for each segment?

Probably or write a loop using the code from an operation as a starter.