Remove dots from text?

[TME1991]

Hello there,

First, I'd like to say that I am not a modder or anything, I am actually a Political Science student. I came across this forum while I was searching for a solution to my problem.

Anyway, on a site I'm registered to, there are random codes posted sometimes that you can win stuff from. You have to copy the code and insert it in a text box but remove the dots (.) from the codes. Of course that takes a while to do and I never win lol.

Is there a way to do that on Microsoft Office or Microsoft Excel? What I mean is, can I, for instance, copy the code from the browser, paste it to Office/Excel and it would automatically remove the dots, and then I'd copy and paste it in the browser? That process shouldn't take more than 1 or 2 seconds if done correctly.

I have heard about Macros, but I am not unable to use them. This is the code that supposedly does that:

f = open( "test.txt", "r" )
text = f.read()
f.close()

newText = ""
for each in text:
    if each == ".":
        each = "" #Or replace it with whatever you like.
    newText += each

f = open( "output.txt", "w" )
f.write( newText )
f.close()

But I neither understand it nor know how to use it.

Thank you, guys.

EDIT: This is the type of codes I'm taling about - .US1337-Z.37HQLW.279N92Q8R1TH3QQLPT

 

[VoG]

Try like this

Excel Workbook
	A	B
1	a.b.c.d.e.	abcde
Sheet1

 

[Weaver]

If you have excel, paste your code into A1 and enter the following formula in B1

=substitute(A1,".","")

HTH

 

[TME1991]

Thank you so, so much, guys. That worked like a charm!

I never knew Excel can do stuff like that, I always just guessed. Guess I have a lot of learning to do!

 

[Weaver]

Out of interest, where did that bit of code come from?

 

[TME1991]

http://www.daniweb.com/software-development/python/threads/239037

 

[Weaver]

I see. Probably wouldn't have helped you much if you had got it working, since you'd need to save all your codes to a text file, close it, run the code and then reopen the text file to get your results.

 

[TME1991]

Agreed. I was looking for something quicker, which you and VoG nicely provided.