>ex.. >field1 field2 >1 1 >2 2345 >3 8765 >4 987 > 2 >1 2672 >2 09876 >3 87654 >4 1287 > 3 >. >.*****************i need to replce it as > >1 1 >1 2345 >1 8765 >1 987 > 2 >2 2672 >2 09876 >2 87654 >2 1287 > 3 >3 7654 >3 3456 >3 7654 >3 3987 > 4 >. . >. > >>thanks
lNumber=field1 do while !eof() replace field1 with lNumber while {condtion here, maybe field2#lNumber+1 or maybe not isblank(field1)} lNumber=lNumber+1 enddo