CalcBuilder Forum

Loading CSV file into Matrix

User moon_336 2012-03-27 22:47:18

Hi,

I have tried many methods to get a CSV file loaded into a matrix but can't seem to get the matrix to format correctly with 6 columns.

I end up with 1 column and all 6 column values per row entered into the 1 cell of each row in the single column.

Please advise.


Aaah, I have this sorted. No problems.

Thanks

Edited by moon_336 - 28.03.2012 09:55

Moonsoft support 2012-03-28 10:01:17

Hello,

We can see you have a solution ;) . Although we write some basic cvs tips to help anyone in forum.

CSV column content should be without "" or '' and separate colum char are ;

For example:

;1;2;3
A0;A1;A2;A3

This csv code creates 2 rows with 4 colums (first column of first row is not considered).

Hope this helps. Regards,

Moonsoft Team

...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!
...
List Manager

Build different lists for your site

Buy now!