Help Guys

jamespeterson

Registered Member
Joined
Mar 29, 2018
Messages
85
Reaction score
20
I have a huge list of username (more than 10k)
for example
@xxx1
@xxx2
@xxx3
@xxx4
@xxx5
@xxx6

i want to change them to @xxx1 @xxx2 @xxx3 @xxx4 @xxx5
is there any software to do this?
 
You mean you want to change them from Vertical to Horizontal ?
You can easily do that using Excel.
 
Excel

Copy the cells, right click and Paste Special (Transpose)
 
I'm feeling adventurous today

this python code :)
Code:
lines = [line.rstrip('\n') for line in open('oldfile.txt')]
thefile = open('newfile.txt', 'w')
for item in lines:
  thefile.write("%s " % item)
 
thank you i'll try it
No. Don't bother installing python for this. :p Use excel like the others suggested. You can even notepad++.

If u still have difficulty pass me the file, I'll do it for u. (no, i dont want ur usernames, i can write a simple bot to scrape em easily)

Edit: u deleted the reply? Now i feel like a fool :confused:
 
No. Don't bother installing python for this. :p Use excel like the others suggested. You can even notepad++.

If u still have difficulty pass me the file, I'll do it for u. (no, i dont want ur usernames, i can write a simple bot to scrape em easily)

do you know the formula for excel?
 
You mean you want to change them from Vertical to Horizontal ?
You can easily do that using Excel.

do you know the formula?

No. Don't bother installing python for this. :p Use excel like the others suggested. You can even notepad++.

If u still have difficulty pass me the file, I'll do it for u. (no, i dont want ur usernames, i can write a simple bot to scrape em easily)

Edit: u deleted the reply? Now i feel like a fool :confused:

sorry i delete it because i accidentally upload image
 
Paste them as text from your *.txt file into Excel.

Then copy the cells in Excel again, right click Paste Special and select Transpose.
 
Back
Top