For x=1 to getwordcount(bn,',') tempbn=getwordnum(bn,x,',') **your code here Endfor>Quick overview, I have a page that lets a user type in a record number and get the record info exported into an Excel spreadsheet. Right now it only works with one number at a time, but I want to allow them to type multiple record numbers separated with commas.
OpenTable(goWCServer.oConfig.oTask.cBTSPath+[key\A]+m.bn,[AppExp]) > > > > *Select columns from table above, name them for Excel headers > SELECT bn as [BatchNum],; > pk as [RecNo],; > "" as [Approved],; > shdt as [ShipDate],; > canm as [Carrier],; > prno as [Pro],; > blno as [BOL],; > shnm as [Shipper],; > ozp as [OZip],; > conm as [Consignee],; > dzp as [DZip],; > wtttl as [Weight],; > "" as [ReWeigh],; > "" as [Notes],; > accd1 as [Acc1],; > acamt1 as [Amt1],; > accd2 as [Acc2],; > acamt2 as [Amt2],; > accd3 as [Acc3],; > acamt3 as [Amt3]; > FROM AppExp; > into cursor ApprovalA > > > SELECT ApprovalA >*Copy data from cursor to Excel file >COPY TO ("C:\test\"+[bn]+m.bn+[T2.xls])>