VBA to remove a certain string in a Text file.

Hi.

Would like to seek help in removing the bold characters in my .txt file below.

00012345678912345678912
1234546
123456
12345
00012345678912345678950041
1234546
123456
12345
00032345678912345678901510
1234546
123456
12345
000423456789123456789540
1234546
123456
123450
00071234567891234567890520
1234546
123456
12345
00071234567891234567890510
1234546
123456
12345
000612345678912345678904505
1234546
123456
12345
000612345678912345678907451
1234546
123456
12345
00011234567891234567890450121
1234546
123456
12345

I want to remove the 4th digit of the 1st line and every 5th line from the last modified line.

Thanks in advance.

Im want to learn VBA, are there any links of VBA easy tutorials?

Hi,

how distinguish modified text from the unaltered text?
Think about that.

Try

Please Login or Register  to view this content.

Originally Posted by jindon

Try

Please Login or Register  to view this content.

Thanks... This is exactly what i needed..

But if i wanted to remove 1 more line just like below?

00012345678912345678912
1234546
123456
00012345678912345678950041
1234546
123456
00032345678912345678901510
1234546
123456
000423456789123456789540
1234546
123456
00071234567891234567890520
1234546
123456
00071234567891234567890510
1234546
123456
000612345678912345678904505
1234546
123456
000612345678912345678907451
1234546
123456
00011234567891234567890450121
1234546
12345

Still to remove the 4th digit of the 1st line and every 4th line from the last modified line.

Originally Posted by TudyBTH

Hi,

how distinguish modified text from the unaltered text?
Think about that.

A new txt file should be created, because the original data should still be retained.

Thank you.

It doesn't matter every 4th or 5th line.
It remove the 4th character from the lines that have more than 19 digits.

Isn't that what you wanted?

Originally Posted by jindon

It doesn't matter every 4th or 5th line.
It remove the 4th character from the lines that have more than 19 digits.

Isn't that what you wanted?

Apologies, i have been unclear about this.. But sometimes the lines can have characters as long or as short as the other lines. I need to remove the 4th character in the 1st line, 4th line, 7th line, 10th line, 13th line.. and so on. Thank you.

Then adjust Step 3 (every 4th) as you require. e.g. 4 for every 5th.

Please Login or Register  to view this content.

Exactly!... Thank you very much..

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.