Read sequences from .txt file, then move to new line

[Gintaras]

Macro Macro1811

Code:

Copy      Help

str s=
;[email protected],johndoe,doepassword
;[email protected],jackj87,mypass123
;[email protected],anonmouse,cheesepw
;[email protected],wowguy61,wowrulesspassword

ARRAY(str) a=s
int i
for i 0 a.len
,str email user password
,if(tok(a[i] &email 3 ",")<3) end "bad format"
,email.trim; user.trim; password.trim
,out F"email=''{email}'',  user=''{user}'',  password=''{password}'"
,;here
,;add
,;code
,;that
,;uses
,;the
,;data

The list looks like in CSV format. If so, better use ICsv interface.
Macro Macro1812

Code:

Copy      Help

str s=
;[email protected],johndoe,doepassword
;[email protected],jackj87,mypass123
;[email protected],anonmouse,cheesepw
;[email protected],wowguy61,wowrulesspassword

ICsv x=CreateCsv(1)
x.FromString(s) ;;or use FromFile("file path") to load directly from file
int i
for i 0 x.RowCount
,str email(x.Cell(i 0)) user(x.Cell(i 1)) password(x.Cell(i 2))
,out F"email=''{email}'',  user=''{user}'',  password=''{password}''"
,;here
,;add
,;code
,;that
,;uses
,;the
,;data