Copy different items in different files
Posted: Wed Apr 08, 2015 7:54 pm
Hello everyone,
I am very new at this kind of thing, and need some help from my fellow users. I do have the pro version already as i am quite sure a batch process is going to be required for what I need. I have created a .bat file to copy a page hundreds of times with file names from a list I had created in Excel. I now have a list in Excel with the first 4 items in column A being the existing text i want to find, and 4 items in column b being what i want to replace it with. This goes on and on and on.
M139_D2_10A UnitA01.Cell_State M139_D2_10A UnitA01.Cell_State
M139_D2_10A UnitA02.Cell_State M139_D2_10A UnitA02.Cell_State
M139_D2_10A UnitA03.Cell_State M139_D2_10A UnitA03.Cell_State
M139_D2_10A UnitA04.Cell_State M139_D2_10A UnitA04.Cell_State
M139_D2_10A UnitA01.Cell_State M139_D2_10A UnitA05.Cell_State
M139_D2_10A UnitA02.Cell_State M139_D2_10A UnitA06.Cell_State
M139_D2_10A UnitA03.Cell_State M139_D2_10A UnitA07.Cell_State
M139_D2_10A UnitA04.Cell_State M139_D2_10A UnitA08.Cell_State
M139_D2_10A UnitA01.Cell_State M139_D2_10A UnitA09.Cell_State
M139_D2_10A UnitA02.Cell_State M139_D2_10A UnitA10.Cell_State
M139_D2_10A UnitA03.Cell_State M139_D2_10A UnitA11.Cell_State
M139_D2_10A UnitA04.Cell_State M139_D2_10A UnitA12.Cell_State
File names read as follows.
Battery Data M139_D2_10A_A01_A04.aspx
Battery Data M139_D2_10A_A05_A08.aspx
Battery Data M139_D2_10A_A09_A012.aspx
Battery Data M139_D2_10A_A013_A016.aspx
Battery Data M139_D2_10A_A017_A020.aspx
Battery Data M139_D2_10A_A021_A024.aspx
What i am needing is for it to run the first 4 rows on file 1, goto file 2 do the next 4 rows, rinse repeat until end of file. Any help would be much appreciated in this matter. I will be doing the same exact thing with 7 other words but assume it can all be extrapolated from 1 instance and referenced to the remaining 7. I look forward to any advice, and hope i can be of help to someone else in the future.
I am very new at this kind of thing, and need some help from my fellow users. I do have the pro version already as i am quite sure a batch process is going to be required for what I need. I have created a .bat file to copy a page hundreds of times with file names from a list I had created in Excel. I now have a list in Excel with the first 4 items in column A being the existing text i want to find, and 4 items in column b being what i want to replace it with. This goes on and on and on.
M139_D2_10A UnitA01.Cell_State M139_D2_10A UnitA01.Cell_State
M139_D2_10A UnitA02.Cell_State M139_D2_10A UnitA02.Cell_State
M139_D2_10A UnitA03.Cell_State M139_D2_10A UnitA03.Cell_State
M139_D2_10A UnitA04.Cell_State M139_D2_10A UnitA04.Cell_State
M139_D2_10A UnitA01.Cell_State M139_D2_10A UnitA05.Cell_State
M139_D2_10A UnitA02.Cell_State M139_D2_10A UnitA06.Cell_State
M139_D2_10A UnitA03.Cell_State M139_D2_10A UnitA07.Cell_State
M139_D2_10A UnitA04.Cell_State M139_D2_10A UnitA08.Cell_State
M139_D2_10A UnitA01.Cell_State M139_D2_10A UnitA09.Cell_State
M139_D2_10A UnitA02.Cell_State M139_D2_10A UnitA10.Cell_State
M139_D2_10A UnitA03.Cell_State M139_D2_10A UnitA11.Cell_State
M139_D2_10A UnitA04.Cell_State M139_D2_10A UnitA12.Cell_State
File names read as follows.
Battery Data M139_D2_10A_A01_A04.aspx
Battery Data M139_D2_10A_A05_A08.aspx
Battery Data M139_D2_10A_A09_A012.aspx
Battery Data M139_D2_10A_A013_A016.aspx
Battery Data M139_D2_10A_A017_A020.aspx
Battery Data M139_D2_10A_A021_A024.aspx
What i am needing is for it to run the first 4 rows on file 1, goto file 2 do the next 4 rows, rinse repeat until end of file. Any help would be much appreciated in this matter. I will be doing the same exact thing with 7 other words but assume it can all be extrapolated from 1 instance and referenced to the remaining 7. I look forward to any advice, and hope i can be of help to someone else in the future.