asked on

How to add numbers to a word doc table showing PTR records?

All,

I'm looking at a list of PTR records wiithin Word 2007 and I need to add a "1." in front of a list of objects.

For example:
1 PTR name.domain.com
10 PTR name.domain.com
100 PTR name.domain.com

Is there a way to quickly add "1." to the entire list?

So it would like this when completed?
1.1 PTR name.domain.com
1.10 PTR name.domain.com
1.100 PTR name.domain.com

Thanks

bluemeln

The easiest method is to use Find/Replace, e.g. replace any instance of "1" with "1.1" or similar. If your numbers are increasing, it would take a little forethought which numbers to replace first so that you do not add up with "1.1.1" at some point.

Admin_Stooge

ASKER

The numbers range from 1 to 500 and maybe more

bluemeln

Can you be a bit more specific? If these are IP addresses, the numbers would only go to 255. I was assuming that each number represented an octet in an IP address or subnet mask, so 1.10 would be the end of for example 192.168.1.10. What would a larger finished number look like?

Admin_Stooge

ASKER

When checking the file again, the highest number is 253 and no these numbers are not IPs. These are Zone Records

1 PTR      name.domain.com
10 PTR      name.domain.com
PTR      name.domain.com
100 PTR      name.domain.com
101 PTR      name.domain.com
102 PTR      name.domain.com
PTR      name.domain.com
PTR      name.domain.com
103 PTR      name.domain.com
104 PTR      name.domain.com
108 PTR      name.domain.com
109 PTR      name.domain.com
11 PTR      name.domain.com
PTR      name.domain.com
110 PTR      name.domain.com
111 PTR      name.domain.com
114 PTR      name.domain.com
115 PTR      name.domain.com
116 1200      PTR      name.domain.com
117 PTR      name.domain.com
118 PTR      name.domain.com
119 PTR      name.domain.com
12 PTR      name.domain.com
PTR      name.domain.com
120 PTR      name.domain.com
127 PTR      name.domain.com
128 PTR      name.domain.com
13 PTR      name.domain.com
------------------------------------------------------------------------------------------

So I want to be able to perform a bulk task that will add a "1." to each number
So afterwards it would look like this:

1.1 PTR      name.domain.com
1.10 PTR      name.domain.com
PTR      name.domain.com
1.100 PTR      name.domain.com
1.101 PTR      name.domain.com
1.102 PTR      name.domain.com
PTR      name.domain.com
PTR      name.domain.com
1.103 PTR      name.domain.com
1.104 PTR      name.domain.com
1.108 PTR      name.domain.com
1.109 PTR      name.domain.com
1.11 PTR      name.domain.com
PTR      name.domain.com
1.110 PTR      name.domain.com
1.111 PTR      name.domain.com
1.114 PTR      name.domain.com
1.115 PTR      name.domain.com
1.116 1200      PTR      name.domain.com
1.117 PTR      name.domain.com
1.118 PTR      name.domain.com
1.119 PTR      name.domain.com
1.12 PTR      name.domain.com
PTR      name.domain.com
1.120 PTR      name.domain.com
1.127 PTR      name.domain.com
1.128 PTR      name.domain.com
1.13 PTR      name.domain.com

ASKER CERTIFIED SOLUTION

Stacy Brown

membership

This solution is only available to members.

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

Start Free Trial

bluemeln

By IP addresses I meant that they are portions of IP addresses representing DNS zones. I assume, that the new list with the "1." in front represents a new subnet with a "1" in the third octet. At any rate, here is how you can add "1." in front of any number:
1.      Copy and paste your list into Notepad (not Wordpad) and Save the file.
2.      Open Excel. File > Open > select the Notepad file > the Text Import Wizard comes up > select Fixed Width > select General > Finish.
3.      You now have a table divided in three columns, which allows you to sort the list (and incidentally also get rid of the rows more easily, which do not have a number in the first column).
4.      Highlight the entire first column (the one containing the numbers). In Excel 2003, select Format > Cells > (in Word 2007, select Format > Format Cells... from the Home ribbon) > Number tab > from the Category list, select Custom. In the Type field, type the following string, including the parenthesis:
“1.”###
Click OK to save
This will add 1. in front of every number. Blank fields will be ignored. I tested it here and it worked like a charm.