Hi Brian, 80 characters seems about right 'though I'm not sure I saw any mention of this in Ralph's book.
I have been through your XML presentation but will look through a couple of more times to take it all in. Regards, Michael On 23/04/2010 15:55, Brian Hancock wrote: > 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 > > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
