Hey gurus,
Complete newb here. I am trying to build a macro for removing/replacing text from a .log file using VBA. I know how to set up a find/replace macro, but I need to look for something like "Lot: aaaa, Recipe: bbbb, Layer: cccc" where the aaaa, bbbb, cccc are unknown names of unknown lengths.
In this case I would like to replace "aaaa" "bbbb" and "cccc" with "IP Scrubbed" to result in: "Lot: IP Scrubbed, Recipe: IP Scrubbed, Layer: IP Scrubbed"
I don't know how to find for example "Lot:" and replace the adjacent text "aaaa" (which may be up to 25 characters) with "IP Scrubbed"
Is this possible with VBA or am I taking to wrong approach all together?
Thanks in advance.
Complete newb here. I am trying to build a macro for removing/replacing text from a .log file using VBA. I know how to set up a find/replace macro, but I need to look for something like "Lot: aaaa, Recipe: bbbb, Layer: cccc" where the aaaa, bbbb, cccc are unknown names of unknown lengths.
In this case I would like to replace "aaaa" "bbbb" and "cccc" with "IP Scrubbed" to result in: "Lot: IP Scrubbed, Recipe: IP Scrubbed, Layer: IP Scrubbed"
I don't know how to find for example "Lot:" and replace the adjacent text "aaaa" (which may be up to 25 characters) with "IP Scrubbed"
Is this possible with VBA or am I taking to wrong approach all together?
Thanks in advance.