Hi all,
I am using EXCEL 2007. I have 300+ text files that I need to edit. I would like the entire code, as this is out of my range.![]()
If the second line of the file_1 is greater than zero then
take that number and multiply by 4 (that equals the number of lines to remove/skip)
Make the second line a zero and skip the next number of lines (by the multiplied number)
before: file_1
36
2
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
500.0 250.0 500.0
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
600.0 250.0 600.0
after: file_2
36
0
If second line of file is zero, close file. No reformatting required.
After this reformatting is complete, keep the remainder of the file format the same.
Need a file navigator
The original file should be renamed with the .orig extension
The new file should inherit the original file name