Getnext lookup -

Walter Vaughan wvaughan at steelerubber.com
Thu Dec 4 07:07:26 PST 2008


Preface: I always thought using *clerk as import tool was evil
Recently: Because of working with SQL so much recently I've changed

Senario: Import data from spreadsheet. Two columns, part number and price

@keyR::mesgbox "Replace with data from /tmp/2009changes.csv?","Press y 
or n","yn":
:@bk ne "y":end:
loopU::import word upd=/tmp/2009changes.csv:
:not upd:end:
::pn(10,,g)=upd(1):
::lookup -  k=pn   i=b -nx:
:1 ne pn:show "@No match for "<pn; goto loopU:
udprice::6=upd(2):
::write:
::getnext -:
:1 ne pn:goto loopU:
::goto udprice:

I know this is not production level code, but since I've never
until this morning used "getnext -", I thought I'd pass it on for
someone else who might could use this snippet as an example.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20081204/94d94e7e/attachment.html 


More information about the Filepro-list mailing list