Thanks yet again Brian, I had not used this approach before but it works well.
I am still a little puzzled by the subfield[P1F4;0;n] function not producing something similar though. Michael On 23/04/2010 00:47, Brian Hancock wrote: > Hi Michael, > > DP has some special ways of handling multiline Text Fields in reports. > Especially useful in report with parallel text fields. > > To print out the entirety of an Alphanumeric variable length text field > instead of using the same indicator as on the panel you would use an > indicator like A20A0. > > But lets say you had two Alphanumeric text fields, to output across the same > line. If you output them on the same line with a format indicator like > P1F1:A20A0 and P1F2:A30A0 instead of them being on the same line the P1F1 > field would print out entirely and then the P1F2 field would start printing > on the line below, (or maybe start on the last line of the P1F2 field, I > can't remember which) > > DP Has a special format which allows printing of individual lines, so A20A1 > prints the first line of a field. It then increments a pointer so that if > you again printed the same field with the format A20A1, it would print the > next line, etc. Once you have done this then A20A0 prints out the remainder > of the field > > So to print to aligned text fields you would do this > > F1:A20A1 F2:A30A1 > F1:A20A1 F2:A30A1 > F1:A20A1 F2:A30A1 > F1:A20A1 F2:A30A1 > F1:A20A0 > > You might immediately see a problem - what if you want to print the same > field again in the report. That is handled by the Print Mode Indicator ;;N > which indicates a new occurrence of the field > > So for example lets say you had an address stored in a MultiLine text field > and you need to output it, say for example to an XML file and they were a > maximum of 3 lines long > > <Address> > <Line1> > F1:A50A1;;N > </Line1> > <Line2> > F1:A50A1 > </Line2> > <Line3> > F1:A50A1 > </Line3> > </Address> > > Hope this help > > Brian > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Michael Iannantuoni > Sent: Thursday, 22 April 2010 6:08 AM > To: DataPerfect Users Discussion Group > Subject: [Dataperf] subfield problem > > I have a multi-line text file which is formatted as A38A6 and want to > split it into individual lines. > > In a report I have a number of Report variables set as follows: RV4n set > to subfield[P1F4;0;n] where n = 1 to 6. > > I then print the six Report Variables as A38 but they randomly miss some > of the data from the original A38A6 field. > > Two examples are shown below: > > Joy Griffin > Treasurer, Cottesmore Social Club > 1 St Nicholas Court > Cottesmore > Oakham > Rutland LE15 7BW > > comes out as > > Joy Griffin > Treasurer, Cottesmore Social Club > 1 St Nicholas Court > Cottesmore > O > > and > > Greetham Valley Hotel, Golf and > Conference Centre (attn Sharon) > Wood Lane > Greetham > Oakham > Rutland LE15 7SN > > comes out as > > Greetham Valley Hotel, Golf and Confer > Wood Lane > Gree > > > Can any help please? > > Thanks, > > Michael > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
