| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert line in a text file between 3rd and 4th lines
Hello all,
I have few thousands of XML messages which I need to convert according to new specs. This means, Rule 1: I should insert a line with text "xxxxx" immediately after I see a line with text "aaaaa". Rule 2: I shoud delete all lines with test "yyyy". Rule 3: I should replace "pppp" with "qqqq" etc..etc... I am planing to write a small VB macro in XL to which I give my XML folder as input. This macro should read each file and apply few rules as mentioned above and save the file. Any help in this regard please... how to achieve rule 1, rule 2 and rule 3. I am only aware of WriteLine method with which we can only APPEND the line. Sri -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200902/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert line in first row of CSV text file with VBA | Excel Programming | |||
| Is there a way to skip lines (insert value every other line) | Excel Programming | |||
| Insert line every x lines until end of data | Excel Programming | |||
| macro to insert blank line when lines sum to zero | Excel Discussion (Misc queries) | |||
| Read a .xls file and insert its values to certain lines in a text | Excel Programming | |||
Threaded Mode
