In VB Script, I want find a word in text file and replace it with new word.
In VB Script / Java,
1. I want find a word in text file and replace it with new word.
2. here target(finding word) and replacement word should be taken from a excel file.
3. In text file i will be having more number of instances
finding word: 2016-01-18
replacement word: {{=doDateDeltaFromCurrent("yyyy-MM-dd","-2D");/*2016-01-18*/}}
File:
;:"2016-01-18T04:30:00.000+0000","end":"9999-12-31T00:00:00.000+0000","authorization":{"authCode":"NA"},"secondary":false,"secondaryLiveStreaming":"N","daiEnableMobile":false}],"adult"2016-01-18T04:30:00.000+0000
After Replacement:
;:"{{=doDateDeltaFromCurrent("yyyy-MM-dd","-2D");/*2016-01-18*/}}T04:30:00.000+0000","end":"9999-12-31T00:00:00.000+0000","authorization":{"authCode":"NA"},"secondary":false,"secondaryLiveStreaming":"N","daiEnableMobile":false}],"adult"{{=doDateDeltaFromCurrent("yyyy-MM-dd","-2D");/*2016-01-18*/}}T04:30:00.000+0000
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
StockTrader
8 years ago
Hello,
maybe you'd use the REPLACE function that's available in VB.
You can look here to start with:
Kind regards,
Marco - StockTrader
Posted by:
SMal.tmcc
8 years ago
See this question I answered about that
http://www.itninja.com/question/number-of-autologins-required-has-changed-from-1-to-3-since-3-6-upgrade
http://www.itninja.com/question/number-of-autologins-required-has-changed-from-1-to-3-since-3-6-upgrade