Hi,
I have a macro that loops through a folder containing text files. The macro adds information in the Excel worksheet to each text file in the folder.
I want to add something to the macro that does the following:
In each text file there is a string of information which is the date. The machine that will read this information cannot read it as formatted by the machine that outputs the information.
I would like to have a function that searches the text file for the string that looks like this:
$$ Date: 3/17/2022
and then reformats it somehow to:
Date= 2022/03/17
See the difference? In the second string I have removed the $$, changed the colon to and equals sign and then rearranged the date from m/dd/yyyy to yyyy/mm/dd
Thank you for any help you can give.
I have a macro that loops through a folder containing text files. The macro adds information in the Excel worksheet to each text file in the folder.
I want to add something to the macro that does the following:
In each text file there is a string of information which is the date. The machine that will read this information cannot read it as formatted by the machine that outputs the information.
I would like to have a function that searches the text file for the string that looks like this:
$$ Date: 3/17/2022
and then reformats it somehow to:
Date= 2022/03/17
See the difference? In the second string I have removed the $$, changed the colon to and equals sign and then rearranged the date from m/dd/yyyy to yyyy/mm/dd
Thank you for any help you can give.