asked on

How do I VBS code to add text to end of each line in text file

I have a txt file that I need to add the department number to the end of each line of text like the following you will see I added the 12 in manually. There are sometimes hundreds of lines and I have to add the 12 to the end of each line.

NEW DESTINATION I D 01596 24 WIN12 3.61 4.95 QU 009281015963 10/26/2011 12
NEW WOODEN BOAT 03402 12 N/D11 4.56 6.25 BM 009281034025 10/26/2011 12

Thanks,
Don

SOLUTION

Bill Prew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

jawa29

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dondudley

ASKER

Your are great, worked first time and I have been working on this for at least two hours.

Thanks again.

Don

dondudley

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for dondudley's comment http:/Q_27416534.html#37032705

for the following reason:

I just had to copy the code into my vbs and it worked first time.  I had been working on this for two hours and it only took him minutes.

dondudley

ASKER

Why is there 0 points? I think this was a great job and very fast response.....

Bill Prew

Question needs attention as I think a solution was intended to be accepted.

~bp

dondudley

ASKER

Great Work.