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

[Navyoscar45]

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]

paste file1 file2 on linux

 

[Navyoscar45]

paste file1 file2 on linux

Please could you explain in a lay man terms

 

[HoNeYBiRD]

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]

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]

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

 

[Lauren11]

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

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]

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

 

[Gogol]

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

Edit:

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

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

 

[jl125]

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

 

[MadTeaParticipant]

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

 

[t-machine]

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