how to add a domain name to a hostname

September 21, 2015 at 07:48:51
Specs: Windows 7, 4gb
I have CSV file containing multiple columns and one of it is hostnames. How can we change all the hostnames and include the domain name to it for example the hostname xyz should become This should be automated every time i drop a file with the multiple hosntnames in the path.
thanks in advance.


See More: how to add a domain name to a hostname

Report •

September 21, 2015 at 11:37:28
Do you want to actually change the hostname on existing computers? Or just edit the CSV file to add the domain name to the hostname?

Report •

September 21, 2015 at 20:49:11
@beach: no. Just the csv file. Which would be fairly simple. But I don't do "drag and drop" since the last time I tried to help to use D&D method (someone else, not this poster) I got flamed as a dumb-ass(admitedely, I know "beans" about "drag and drop" and anyway I don't care.).

message edited by nbrane

Report •

September 22, 2015 at 04:48:01
Well... :) Can you open the file in Excel? Or a text editor? Either way, I think simplest is best. Copy and paste it to the end of each hostname. Depending on how many entries you have...and what you're using to edit the file.

In Excel, there's an option to use & to add content to a cell. Again, not knowing what program you're using...

My VBA skills are non-existent, but I'm sure someone here could give you the code to append each entry.

message edited by beachyhbt

Report •
Related Solutions

Ask Question