replacing field in textfile with date

[PWedig]

Hi,
i have to replace a variable or a line in an textfile (unformated) with the actual date.

into the file there are some lines like:

ORDER: { Nr 1 }
ORDERNUMBER:"";
DATE:%date%;
CURRENCA:"EUR";
RELATION:95;
.............

I want to replace every day the word %date% or the complete line with the actual day date. the result should like this:

ORDER: { Nr 1 }
ORDERNUMBER:"";
DATE:11.08.2006;
CURRENCA:"EUR";
RELATION:95;

There are more orders in the file and at every line, where the variable is %date% the result should be there the actual day date.

I have made some scripts with Macro Scheduler but not any replacing any text into a file. smile....

Please give me any idea....

thanks
Peter

[Marcus Tettmar]

Just use the StringReplace function:

Something along these lines:

Year>yyyy
Month>mm
Day>dd
Let>TheDate=%yyyy%.%mm%.%dd%

ReadFile>...

StringReplace>thetext,%date%,TheDate,thetext

[PWedig]

Hello Marcus,

thanks a lot for your help. It's great to get anytime help from you!!!

Here is my result, it's the complet macro because i have had difficulty for the exact defination of every command:

Year>yyyy
Month>mm
Day>dd
Let>TheDate=%yyyy%.%mm%.%dd%

ReadFile>c:\input.txt,file

StringReplace>file,%date%,TheDate,newfile
WriteLn>c:\output.txt,wresult,%newfile%


finished...

best regards

Peter