Problem With Loading Csv, Ubot Studio Doesn't Respect Column Order

[XpownX 8]

Hi all,

 

So I've created a CSV file with ubot studio then I use it on another ubot studio application. This CSV file has 136 rows.

 

This CSV file is structererd in this way:

Column 0:          Column1:        Column2:         Column3:       Column4:

ProductEan          Text               Text or null       Text or null       Text or null 

 

Text or null means that may be multiple text lines or a string that contains:  "Null"

 

Now when I import the CSV with the command: "create table from file", ubot studio fucks up everything, here how it put the csv file inside table:

 

Row1:    ProductEan(Column0)    Text(Column1)

Row2:   Here it inserts all the left out columns of the row1

 

 

 

Can I get some help please? I don't know what is wrong.. the csv file is formatted correctly i might be wrong.. 

 

 

 

 

[hare ram 23]

Check your csv file properly is there any space remaining or save in csv file properly and when take it by table or list separate it by , or other special character.

[bestmacros 60]

verify you don't have comma inside a value in one of the cells, also verify that you don't have single or double quote " inside a value in one of the cells - this is what usually break the csv format.

[Code Docta (Nick C.) 638]

You can try this too...

 

http://network.ubotstudio.com/forum/index.php/topic/22362-code-ubot-custom-function-get-column-from-list/

[HelloInsomnia 1103]

Can you post the file so we can take a look?

[XpownX 8]

The problem is now fixed guys, thanks for the support. It was because of the text inside the csv that wasn't properly formatted