Nominet TAG List

[seanc]

i have sent a request to the automation to request a full list of all the domains on my TAG.

the reply from the automation is a bit of a mess, does anyone have a util or tell me how i can tidy this list up? (can i import to excel?)


Domain Name List follows...
Domain name|reg-status|tag|created|changed|expiry|first-bill|recur-bill|auto-bill|next-bill|dns0|dns0-id|dns1|dns1-id|dns2|dns2-id|dns3|dns3-id|dns4|dns4-id|dns5|dns5-id|dns6|dns6-id|dns7|dns7-id|dns8|dns8-id|dns9|dns9-id|account-id|registrant

 

[SFSF is verified member.]

copy the email from "Domain
name|ips-key|created|first-bill|recur-bill|registrant|reg-contact|reg-tr
ad-name|reg-type|reg-co-no|reg-addr|reg-locality|reg-city|reg-county|reg

processed.|||||||||||||||||ns1.fastpark.net.|ns2.fastpark.net.|||||||||0
|0|20070516|20090516


ie. leave off the bottom text sayiong Number of domains in the list: 1076.

put that in a new text file called list.txt

ok open up excel

then click on the open file thing top left

select the text file you just created

ought to pop up with 'text import wizard'

ok, click next on that first screen

then on the step two window ... it says delimiters

currently has tab selected

see where it says 'other;'

tick other

then in the box by that put |

you will know you have the right one as it will adjust the preview below


hit finish

then its in the spreadsheet

 

[seanc]

unfortunately it hasnt imported it correctly,
its only listed 27 domains out of 100's

somthings wrong somewhere, i'll have a play

 

[seanc]

s0rted...

i switched off text wrap in my Outlook


(thanks DB)

 

[SFSF is verified member.]

oki mate no worries!