Ross,
Thanks for the help. It turned out that I wasn't returning to the
base table at the right place in the loop.
Andy
-----------------------------------------
Andrew Kappy
I.T. Director
Canfield & Tack
Quality Printers Since 1926
925 Exchange Street
Rochester, New York 14608
585-235-7710 ext. 142
On Jun 6, 2008, at 2:25 PM, Andrew Kappy wrote:
This is a better representation of what I'm trying to accomplish
and what I've tried.
Whether I use my original calculation (single variable), the two
variable version, or the custom function, I only get exactly as
desired if I put an actual number for the Occurrence in the
Position function. If I use 1 I get "firstpdf", if I use 2, I get
"secondpdf". That works just fine. However, if I try to use the
variable, $pdfnum or $$pdfnum, I get the first instance just fine
in $$insert, the rest return a blank to $$insert, which I'm
watching in Data Viewer.
In the script example below Line #16 (and disabled #17) are the
lines of interest. Line #17 was my last sample of the calculation
using separate variables for the start and end positions. Line #16
is using the custom function from NRGSoft, which I've named
ExtractXML.
Here is a snippet of the XML source which is imported into the
field: "BaseImportXML::RAW Text".
-------------------------
<POD>
<Order>
<Id>24517</Id>
<ProcessedBy>CT</ProcessedBy>
<Quantity>13</Quantity>
<Spoilage>2</Spoilage>
<TotalQuantity>15</TotalQuantity>
<Type>TEST</Type>
<IncludeInserts>True</IncludeInserts>
<BindItems>
<PDF>firstpdf</PDF>
<PDF>secondpdf</PDF>
<Insert>first insert</Insert>
<Insert>second insert</Insert>
<Insert>third insert</Insert>
<Insert>fourth insert</Insert>
<Insert>fifth insert</Insert>
</BindItems>
-----------------------
Here is the relevant portion of the script:
------------------
1 • Go to Layout [ “BaseImportXML” (BaseImportXML) ]
2 • Perform Find [ Specified Find Requests: Find Records; Criteria:
BaseImportXML::InsertFlag: “0” ] [ Restore ]
3 • Go to Record/Request/Page [ First ]
4 • Loop
5 • Set Variable [ $$orderid; Value:BaseImportXML::OrderID ]
6 • Set Variable [ $$totalquantity;
Value:BaseImportXML::TotalQuantity ]
7 • Set Variable [ $$ordinal; Value:1 ]
8 • Set Variable [ $pdfnum; Value:1 ]
9 • Set Variable [ $pdfnum2; Value:1 ]
10 • Set Variable [ $$insertnum; Value:1 ]
11 • Set Variable [ $$date; Value:BaseImportXML::EntryDate ]
12 • Set Variable [ $$pdfcnt; Value:BaseImportXML::PDFCnt ]
13 • Set Variable [ $$insertcnt; Value:BaseImportXML::InsertCnt ]
14 • #Get PDFs
15 • Loop
16 • Set Variable [ $$insert; Value:ExtractXML ( BaseImportXML::RAW
Text ; "PDF" ; 1 ) ]
17 • // Set Variable [ $$insert; Value:Middle ( BaseImportXML::RAW
Text ; Position (BaseImportXML::RAW Text;"<PDF>";1;$pdfnum)+5;
Position (BaseImportXML::RAW Text;"</PDF>";1;$pdfnum2)-Position
(BaseImportXML::RAW Text;"<PDF>";1;$pdfnum)-5) ]
18 • Go to Layout [ “Inserts” (Inserts) ]
19 • New Record/Request
20 • Set Field [ Inserts::OrderID; $$orderid ]
21 • Set Field [ Inserts::Insert; $$insert ]
22 • Set Field [ Inserts::Ordinal; $$ordinal ]
23 • Set Field [ Inserts::Type; "PDF" ]
24 • Set Field [ Inserts::DateStamp; $$date ]
25 • Set Field [ Inserts::PageCount; 4 ]
26 • Set Variable [ $pdfnum; Value:$pdfnum+1 ]
27 • Set Variable [ $pdfnum2; Value:$pdfnum2+1 ]
28 • Set Variable [ $$ordinal; Value:$$ordinal+1 ]
29 • Exit Loop If [ $$pdfnum>$$pdfcnt ]
30 • End Loop
---------------------
On Jun 6, 2008, at 12:21 PM, Ross Dickson wrote:
Andrew,
Your calculation will give the following results:
$num = 1
Position(Fieldname;"tag";1;1)+3 = 4
Position(Fieldname;"tag2";1;1) = 8
Result = Middle(Fieldname;4;4) = WORD
$num = 2
Position(Fieldname;"tag";1;2)+3 = 11
Position(Fieldname;"tag2";1;2) = 21
Result = Middle(Fieldname;11;10) = ¶tagWORD2t
$num = 3
Position(Fieldname;"tag";1;3)+3 = 16
Position(Fieldname;"tag2";1;3) = 34
Result = Middle(Fieldname;13;18) = WORD2tag2¶tagWORD3
Clearly not what you expected.
I would break each Set Field [WORD, WORD2, WORD3] script step into
two, one to isolate the line containing the word and the
surrounding tags, and the second to isolate the word. Once they
are working you can merge them together, if you wish.
So (FN==Fieldname),
WORD = Middle("¶"&FN&"¶";Position(FN;"¶";1;$num)+1;
Position(FN;"¶";1;1+$num)- Position(FN;"¶";1;$num)-1)
WORD = Middle(WORD; 4;Position(WORD;"tag2";1;1)-4)
Ross
