Hi Michael, Most of the string functions only work with strings up to around 80 chars length, so you might be seeing it work for the first few lines but seemingly randomly not work quite right, I think if you could the characters then you will see where the trouble starts.
Regards Brian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Iannantuoni Sent: Friday, 23 April 2010 6:20 PM To: [email protected] Subject: Re: [Dataperf] subfield problem 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 _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
