Columns And Row Save In Order? Help Please!

[pablo322 1]

Hello , I know there are people who know a lot and I ask you please help me solve this problem

 

 

as I can do to save data in order? I have tried in many ways and I can not do

 

 

Example:

 

   A                                               B                              C                                      D

1  MAIL                                 PASSWORD           RECOVERY MAIL              PHONE NUMBER

2 UYH@HOTMAIL.COM      RFVHJIBRVFUI    UYH@MAILNESIA.COM      1141651919581  

3 EDYH@HOTMAIL.COM    EIVU89FHNRFU  EDYH@MAILNESIA.COM     1654981496158

 

 

I have done this but does not work at all:

 

 

set(#account pass,$account data("Password"),"Global")

set(#account mail,"{$account data("Username")}@hotmail.com","Global")

set table cell(&mail,2,0,#account mail)

set table cell(&pass,0,1,#account pass)

save to file("C:\\Users\\Phenom II\\Desktop\\test donload.csv",&mail)

save to file("C:\\Users\\Phenom II\\Desktop\\test donload.csv","{&mail}{&pass}"

 

 

 

 

Edited June 5, 2016 by pablo322

[HelloInsomnia 1103]

Is this what you are trying to do? I think you want them to be in the same table and not separate tables.

clear table(&accounts)
set(#row,0,"Global")
loop(5) {
    reset account("Any")
    set(#account pass,$account data("Password"),"Global")
    set(#account mail,"{$account data("Username")}@hotmail.com","Global")
    set table cell(&accounts,#row,0,#account mail)
    set table cell(&accounts,#row,1,#account pass)
    increment(#row)
}
save to file("{$special folder("Desktop")}\\test donload.csv",&accounts)

[pablo322 1]

 

Is this what you are trying to do? I think you want them to be in the same table and not separate tables.

clear table(&accounts)
set(#row,0,"Global")
loop(5) {
    reset account("Any")
    set(#account pass,$account data("Password"),"Global")
    set(#account mail,"{$account data("Username")}@hotmail.com","Global")
    set table cell(&accounts,#row,0,#account mail)
    set table cell(&accounts,#row,1,#account pass)
    increment(#row)
}
save to file("{$special folder("Desktop")}\\test donload.csv",&accounts)

 

 

I'll try and let you know , thank you very much !

[pablo322 1]

the problem is in the format excel for default....  

[HelloInsomnia 1103]

the problem is in the format excel for default....

 

I don't use Excel, but I'm guessing you have to probably set the table delimiter to be a comma. Or you may have to set the encoding to be utf-8 - I'm not really sure what Excel is showing you can you screenshot it?

 

The format for which the table is saving is 100% correct, it must be something wrong with Excel. The extension is .csv which literally stands for comma separated values, if you open it in a text editor you will see it is separated by commas so the format is correct.