I have a small project that should be easy for anyone who knows how to make excel scripts/macro
I have a long string:
000002900001230700000020030000152001000039900
I am interested in the 31st-33rd numbers.
I need the file parsed out to that number.
Possibly the best solution would be to make a macro so a single file saved for each of the combination at 31st-33rd.
This would however, create possibly 200+ different txt files, each containing just the strings that contain that specific number.
So these:
000002900002991400000120030000389003000039800
000002900002991500000120030000389001000039300
000002900002991500000120030000389002000039700
000002900002991500000120030000389003000040200
Would be placed in a file entitled 389 along with any others that have 389 at the 31st-33rd location.
And these:
000002900002991400000120030000116003000039800
000002900002991500000120030000116001000039300
000002900002991500000120030000116002000039700
Would be placed in a file entitled 116 along with any others that have 389 at the 31st-33rd location.
The files should have the ability to have it automatically name the text file “my choice”-116.txt
In the macro, it may ask what the name should be. So if I Oakland the files should be created as Oakland-116.txt, Oakland-389.txt, etc.
The macro must work on MS excel Mac 2004 on a Apple iMac
Attached is a sample file to work with.
Needs to be completed by Tuesday Morning. Quick project for anyone who knows what they are doing. Budget $40
Future jobs if result is very good.