A
Angela
Hi,
I have placed a logsheet at location "http://www.filefactory.com/file/
b2bce33/n/uCd1554bv2800rcHj203.txt".
For above log file below is required n excel sheet:
Select files from folder. Browse and just select folder.
Read 1924716 & add "0000" at the end i.e. 19247160000 This is starting
serial.
Read 400 & stop at "19247160399" i.e. the 400th serial. This is the
end serial.
Read 1924717 & add "0000" at the end i.e. 19247170000 This is
starting serial.
Read 400 & stop at "19247170399" i.e. the 400th serial.This is the end
serial....... and so on
File name is 1554. File name for first serial batch should be 1554 +
1. Second batch should be + 1 to previous and so on.. like 1555, 1556,
1557 and so on.
Add zero to all the start & end serials.
StartSerial EndSerial Quantity FILE DATE
019247160000 019247160399 400 1555 14/02/2009
019247170000 019247170399 400 1556 14/02/2009
019247180000 019247180399 400 1557 14/02/2009
019247190000 019247190399 400 1558 14/02/2009
019247200000 019247200399 400 1559 14/02/2009
019247210000 019247210399 400 1560 14/02/2009
019247220000 019247220399 400 1561 14/02/2009
Thanks.
I have placed a logsheet at location "http://www.filefactory.com/file/
b2bce33/n/uCd1554bv2800rcHj203.txt".
For above log file below is required n excel sheet:
Select files from folder. Browse and just select folder.
Read 1924716 & add "0000" at the end i.e. 19247160000 This is starting
serial.
Read 400 & stop at "19247160399" i.e. the 400th serial. This is the
end serial.
Read 1924717 & add "0000" at the end i.e. 19247170000 This is
starting serial.
Read 400 & stop at "19247170399" i.e. the 400th serial.This is the end
serial....... and so on
File name is 1554. File name for first serial batch should be 1554 +
1. Second batch should be + 1 to previous and so on.. like 1555, 1556,
1557 and so on.
Add zero to all the start & end serials.
StartSerial EndSerial Quantity FILE DATE
019247160000 019247160399 400 1555 14/02/2009
019247170000 019247170399 400 1556 14/02/2009
019247180000 019247180399 400 1557 14/02/2009
019247190000 019247190399 400 1558 14/02/2009
019247200000 019247200399 400 1559 14/02/2009
019247210000 019247210399 400 1560 14/02/2009
019247220000 019247220399 400 1561 14/02/2009
Thanks.