Need Code for .txt file Modification. I have say 100 .txt file in one folder want to change something in that.
Process. On Button Click.
Very first file of that folder location & find that .txt file name in workbook – Source –Sheet – Data. In column B. If not found then go for next .txt file. If found then need to modify very first line of .txt file from “<TICKER>, <PER>, <DTYYYYMMDD>, <TIME>, <OPEN>,<HIGH>,<LOW>,<CLOSE
“<TICKER>, <NAME>, <PER>,<DTYYYYMMDD>,<OPEN>,
i.e. “<NAME> added & <TIME> removed.
Whole data in text file is in this manner “xyz,D,20050422,000000,59,
Need to add <TICKER> in that & Remove <TIME> from data i.e. “A,xyz,D,20050422,59,59,47
ticker found i.e. “A” from source file sheet data column C which is matching with its name in column B.
Sava this new .txt file with its name as Ticker in same location.
i.e. now “xyz.txt” to “A.txt” move to next till end.
See attached Files.