https://forge.codesys.com/forge/talk/Runtime/thread/75cd0cabb2/2020-02-27T15:23:02.834000ZRecent posts to read big csv file2020-02-27T15:23:02.834000Z2020-02-27T15:23:02.834000Zjosepmariaramshttps://forge.codesys.com/u/josepmariarams/https://forge.codesys.com34f63825c9c95043448b214ec72397efd37d7b69

<div class="markdown_content"><p>Hi.</p> <p>I made some mistakes on last code (in _new):</p> <p>That is a resume of my code. You have to manage errors on case of reading fail. And at the end parse code over strings is not filled.</p> <p>I have not test it, it could contain some mistakes,</p> <p><img alt="IMG: Captura de 2017" rel="nofollow" src="https://forum.codesys.com//download/file.php?id=2771"/></p></div>

2020-02-27T15:23:00.901000Z2020-02-27T15:23:00.901000Ztonverrahttps://forge.codesys.com/u/tonverra/https://forge.codesys.comb13fea1ccd29ae463f9bbb4de411459eac85c363

<div class="markdown_content"><p>Thank you so much! </p></div>

2020-02-27T15:23:00.256000Z2020-02-27T15:23:00.256000Zjosepmariaramshttps://forge.codesys.com/u/josepmariarams/https://forge.codesys.com3fc927bd0d53c30d9a4f3e0857c4ed78acfdd840

<div class="markdown_content"><p>Hi.</p> <p>this is a simplified example:</p> <p>I recomend to you that a buffer be in a separate FB which manages the construction and destruction of it,</p> <p>The same for the double array, an FB with the double array and get and set methods to control array bounds.</p> <p>In array creation add 1 byte more to put the last string 0.</p> <p><img alt="IMG: Captura de 2017" rel="nofollow" src="https://forum.codesys.com//download/file.php?id=2770"/></p></div>

2020-02-27T15:22:58.403000Z2020-02-27T15:22:58.403000Ztonverrahttps://forge.codesys.com/u/tonverra/https://forge.codesys.com5175701d10588253a385dc6a1f4b7e35c482007a

<div class="markdown_content"><p>Thanks for the explanation!</p> <p>Any chance you could post some example code/project?</p> <p>I got it to work, but am looking at individual bytes (ASCII) and combining/converting those to INTEGER values. I am sure there are more elegant ways of doing this..</p></div>

2020-02-27T15:22:57.762000Z2020-02-27T15:22:57.762000Zjosepmariaramshttps://forge.codesys.com/u/josepmariarams/https://forge.codesys.com25b200a1309c91a7ad5f94059620014f0c47ede7

<div class="markdown_content"><p>Hi.</p> <p>For reading csv, first i ask about csv size using sysfile.getsize, after that i make a __new(byte,size+1) over a byte pointer.</p> <p>To read values, you can create an array of arrays of pointer to string (first array are rows). You can go over the big array pointing the strings after field separators and subst the field separator by an 0. (End line changes first array).</p> <p>You can put all inside a fb and acces fields via get(x,y).</p> <p>Don't forget to destroy dynamic memory previous a new read and destroy it in fb_exit.</p> <p>To write csv, the dynamic array is a little bit mor complicated.</p></div>

2020-02-27T15:22:57.115000Z2020-02-27T15:22:57.115000Ztonverrahttps://forge.codesys.com/u/tonverra/https://forge.codesys.comb56da18fd58c26e295ba1e90bb469c456453b261

<div class="markdown_content"><p>Hi!</p> <p>If I may hook into your thread.. </p> <p>Do you have any luck with this?<br/> Are you able to do this with smaller csv files?<br/> Where do you store your csv?</p></div>

2020-02-27T15:22:55.197000Z2020-02-27T15:22:55.197000Zhki75https://forge.codesys.com/u/hki75/https://forge.codesys.comf48d78d171903e083b41ed5648c43f8ee5310674

<div class="markdown_content"><p>in order to read a csv file, I usually use the FILE.Read FB from File from CAA_File.Library</p> <p>The read data is stored into the the ADR(buff) area: how get big amount of data? (buffer size &gt;xxxxxxxxxxxxx): Get multiple file-read?how to split reading operations?</p> <p><img alt="IMG: 05" rel="nofollow" src="https://forum.codesys.com//download/file.php?id=2639"/></p></div>