• Buy & Sell your domain names commission free on Canada's most trusted domaining community.
    Get your own landing page with a custom website address dn.ca/market/user at: Market Pages

Transfer Codes starting with the symbol = (1 Viewing)

MapleDots

Community Guide
Verified Member
Boardroom Access
Joined
Nov 4, 2020
Topics
831
Posts
3,550
Likes
3,055
Market
sheets-formula.png



I use Godaddy for a lot of my domains and they have a neat feature where you can download a spreadsheet of all your domains. You can customize the fields and if you download all of the fields it is shocking how much information it contains about each domain.

You can download the spreadsheet with or without the transfer codes which are placed in the last field if you request them.

I hate having a transfer code that starts with the = sign and I think it should be abolished as the first character in transfer codes. The spread sheets looks at it as a command and shows it as an error.

So every time I look at my spreadsheet I see a few errors unless I put something in front of the = sign but then the transfer code is no longer accurate.

Third world problems, I know but nonetheless problematic
 

aactive

R.I.P.
Joined
Nov 11, 2020
Topics
23
Posts
372
Likes
370
Use find/replace in Excel, which should solve that in a few seconds.
 

rlm

Highest Like Count
Notable Member
Joined
Nov 7, 2020
Topics
57
Posts
1,429
Likes
1,354
Well, I'm not sure how that would work. Find/Replace can't match ONLY equal signs at the front of a string. And you'd want to retain the actual auth code that includes the =, not get rid of, change it, nor prefix it with a single quote either...

You _should_ be able to simply change the formatting of the cell to text and excel should then _not_ try and interpret it as anything but literal text only. But it doesn't, unfortunately. In my version of excel, I can create a new column, format it first as text, then I can type =lksdjflskdfjlskj in a cell and it doesn't interpret it as a formula. This leads you to believe that if you formatted a blank column as text, then special pasted the column as text into the newly text formatted column, that it would do exactly that. But for me, that doesn't work either. Hand typing in the text formatted cells interprets it as only text like you'd expect (not interpreting it as a formula). But "special paste" as text pastes it, but then it still interprets the equal sign as a formula again. Counter-intuitive and frankly frustrating. I'm using an older version of excel on my mac, maybe the latest version has fixed that?
That method might at least be worth a try Frank....
 

MicahDomains

Member
Joined
Feb 20, 2021
Topics
57
Posts
142
Likes
78
Market
The escape function may work. For example, to put the text "=55DA" in a cell, type the text below in the cell.

'=55DA

The spreadsheet will not interpret as formula and automatically remove the single quotation. So same principle as placing something in front of the code, but in this instance spreadsheet will display correct code and automatically remove quotation.
 

MapleDots

Community Guide
Verified Member
Boardroom Access
Joined
Nov 4, 2020
Topics
831
Posts
3,550
Likes
3,055
Market
Nothing works for me, if it is a plain text field it removes the = and then it is the wrong code.
If I add something in front of the = then it is still the wrong code.

I am using google sheets but I know it is the same with Excel.

It's frustrating because with so many domains I simply download the data and always have to correct the code starting with = and it may be my look but I always have 5 or 6 of them.
 

rlm

Highest Like Count
Notable Member
Joined
Nov 7, 2020
Topics
57
Posts
1,429
Likes
1,354
yeah, that was the point I was trying to make, you don't want to modify the actual auth code just to make it display properly - because when the time comes to transfer a domain, you're going to cut-and-paste it...

It's _truly_ a display issue which is why there should be some formatting function to fix it, but there is not...

Some registrars allow you to generate a new auth code any time you like. If that is possible at GoDaddy - maybe just regenerate the auth codes that have equal signs at the front....
 

MapleDots

Community Guide
Verified Member
Boardroom Access
Joined
Nov 4, 2020
Topics
831
Posts
3,550
Likes
3,055
Market
rlm said:
Some registrars allow you to generate a new auth code any time you like.  If that is possible at GoDaddy - maybe just regenerate the auth codes that have equal signs at the front....

Not sure if they have that function but it is worth checking out.
 

FM

WHC.ca
Service Rep.
Verified Member
Boardroom Access
Joined
Nov 20, 2020
Topics
53
Posts
722
Likes
520
I don't have excel handy, but you should be able to use the replace function by escaping the "=" character with a backslash. So find:
\=
and replace it with something that works for you.

Also if the column is formatted as "text", shouldn't it ignore Formulas? Maybe not.