Member Avatar for -ordi- 
print divmod(1024, 26) # 39
print chr(39 + ord('A') - 1) # g

but:

AA, AB etc, how to convert this to number?

Edited by -ordi- because: n/a
  • 2 Contributors
  • 3 Replies
  • 121 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by TrustyTony

Recommended Answers

All 3 Replies

Member Avatar for TrustyTony

If I understand your question, you asking what number is aa in base 26:

int('aa',26)
270
Member Avatar for -ordi-

If I understand your question, you asking what number is aa in base 26:

int('aa',26)
270

Alphabet:

a, b, c, ....., z (there are 26 standard), and aa = 27 and ab = 28.

It's my idea.

Edited by -ordi- because: n/a
Member Avatar for TrustyTony

Here I prepare list of values and multiply by positional radix 26 power.

startpoint=ord('a')-1
sum( 26**value*num
     for value,num in enumerate(reversed([ord(char)-startpoint
					  for char in 'bc'])))

55

But how would you express zero?

Edited by TrustyTony because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.