incrementing with repition

[goeagles]

I'm importing 500,000+ records froma tab delemited file. The file does not have package IDs and I need to create them. the logic is that the package ID starts with 000000001 and increments by one after the tenth record. I would appreciate any insight in to how I do this. Would the Let function be what I'm looking to use and if so can you suggest a syntax?

[fabriceN]

Maybe

serialIncrement ( "000000000" ; Ceiling ( get ( recordnumber ) / 10 ))

Edited May 13, 2008 by Guest