How Do I Scrape A Item From A List?

[loadsofthema 0]

I purchased 1000 russian emails, and they come in a txt file using this format:

 

safiullin.romochka@inbox.ru:password

miss.tararushkina@list.ru:password

nice.skorokhodko@bk.ru:password

khvoevskayaa@bk.ru:password

 

 

and so on.

 

 

I know how to create a list from a txt file, but how do i get the value before the : to place as username, and then the value after the : to place it in the password field?

 

I know how to put text in the fields, but i do not know how to gather the text from this kind of list, I usually do it with tables. Is there an easy way to convert this file into a table with the username in the first column and the password in the second?

[deliter 203]

I probably have the worst regex skills here but maybe that would help you since it is day one beginner quality

this basically says to find anything from the start of a line up to an @ ,then anything after the @ up to the .ru

set(#file,"safiullin.romochka@inbox.ru:password
miss.tararushkina@list.ru:password
nice.skorokhodko@bk.ru:password
khvoevskayaa@bk.ru:password","Global")
add list to list(%emails,$find regular expression(#file,".+?@.+?\\.ru"),"Delete","Global")

[loadsofthema 0]

Well, I already have completed the bot, what i did was confert text to a table in excel, in excel 2016 it's done by clicking data> text to columns. As i got a table from doing that, i used it for the bot.

[stanf 43]

if your not into regex

 

set(#list od data,"safiullin.romochka@inbox.ru:password
miss.tararushkina@list.ru:password
nice.skorokhodko@bk.ru:password
khvoevskayaa@bk.ru:password","Global")
add list to list(%list od emails,$list from text(#list od data,$new line),"Delete","Global")
loop(1) {
    add list to list(%email on one line pass on next,$list from text($list item(%list od emails,1),":"),"Delete","Global")
}