What software can I use to arrange words in a file/document

Navyoscar45

Regular Member

Nov 13, 2018

435

94

• Sep 17, 2019

• #1

For example i have a txt file containing username , password , Gmail.
& I want to rearrange it to ;
Username,password, then add; proxies ,,,Tru
So it will be
Username, password,proxies,,,Tru


Please what software can do this

 

KenWalker

Junior Member

May 28, 2019

175

99

• Sep 17, 2019

• #2

paste file1 file2 on linux

 

Navyoscar45

Regular Member

Nov 13, 2018

435

94

• Sep 17, 2019
• Thread Starter Thread Starter

• #3

KenWalker said:

paste file1 file2 on linux

Click to expand...

Please could you explain in a lay man terms

 

HoNeYBiRD

Elite Member

May 1, 2009

10,187

12,580

• Sep 17, 2019

• #4

If the text is formatted in an orderly fashion, just copy-paste it into an empty Excel document. Then you can select a separator (in your example the comma), and split the text into columns, so you'll have the usernames in column A, the passwords in column B etc. When the data is formatted like that, you can easily swap/rearrange columns.

https://www.extendoffice.com/documents/excel/1786-excel-split-text-by-space.html#a1

 

KenWalker

Junior Member

May 28, 2019

175

99

• Sep 17, 2019

• #5

if you have access to linux system
put both files in same directory
if your file1 has
name,add,other_info and your 2nd file has proxyort

then run the command
paste <file1> <file2> | tr -s "\t" "," > newfile

i dont know if i can explain more

 

tubeboost

Elite Member

Jr. VIP

Sep 24, 2014

2,648

1,519

• Sep 17, 2019

• #6

Notepad++ is the best (and free) software to this kind of operations.

 

L

Lauren11

Regular Member

Nov 21, 2018

435

100

• Sep 17, 2019

• #7

Navyoscar45 said:

For example i have a txt file containing username , password , Gmail.
& I want to rearrange it to ;
Username,password, then add; proxies ,,,Tru
So it will be
Username, password,proxies,,,Tru


Please what software can do this

Click to expand...

I am not too good in regex but google it remove everything before a single chatacter notepad++

Seems this tool do the job.
https://le-tools.com/XL-Tools.html

 

Navyoscar45

Regular Member

Nov 13, 2018

435

94

• Sep 17, 2019
• Thread Starter Thread Starter

• #8

Thank you all , for the wonderful advice.
Please any more suggestions

 

Gogol

Administrator

Staff member

Moderator

Executive VIP

Jr. VIP

Sep 10, 2010

11,823

26,665

• Sep 17, 2019

• #9

How about using a spreadsheet program? Seems like a classic case for that. Don't overthink it lol.

Edit:

HoNeYBiRD said:

If the text is formatted in an orderly fashion, just copy-paste it into an empty Excel document. Then you can select a separator (in your example the comma), and split the text into columns, so you'll have the usernames in column A, the passwords in column B etc. When the data is formatted like that, you can easily swap/rearrange columns.

https://www.extendoffice.com/documents/excel/1786-excel-split-text-by-space.html#a1

Click to expand...

Yup! That's the only sensible suggestion in this thread lol.

 

J

jl125

Newbie

Oct 10, 2019

22

3

• Oct 10, 2019

• #10

Can be done in like 3 lines of code. Look into parsing files with python.

 

M

MadTeaParticipant

Newbie

Nov 23, 2019

3

0

• Nov 23, 2019

• #11

it's comma delimited? just save it as a csv and manipulate it in excel from there

 

t-machine

Junior Member

Nov 17, 2019

110

60

• Nov 23, 2019

• #12

I gotchu buddy For the complete non-knowledgable average joe : https://www.browserling.com/tools/

1. Remove extra whitespaces / remove all whitespaces tool
2. Replace text tool
3. Add suffix tool