Search & Replace a text file with batch script
I am stuck with a problem,
I need to search and replace a value in a text file every 24 hrs. I know how to do the scheduling but I don't know how to write a batch file to do it.
This is a typical line in the text file:
2014-06-30 01 M052013-N_1001-MX4501 95893,09
The first group is DATE, the second is HOUR, the third is a KEY and the fourth is a measured VALUE. The groups are TAB delimited.
What I need to do is to scan the HOUR group and if it is 00 it should be changed to 24 and then the file should be saved.
Help very much appreciated!