Quick Macros Forumhttp://www.quickmacros.com/forum/smartfeed.php?feed_type=ATOM1.0&limit=1%20DAY&sort_by=standard&feed_style=HTML&max_word_size=All2012-05-18T14:58:06+00:00phpBB 3 SmartFeed Modification 2.0.RC3 (mark@phpbbservices.com) (info@mypapit.net)Programming :: ICsv - GetRowMS - and multistring2012-05-17T21:09:46+00:002012-05-17T21:09:46+00:00http://www.quickmacros.com/forum/viewtopic.php?f=4&t=5095#p23185Dana Scenario: I want to reading a csv file into icsv1 then process each line, throwing some away, modifying others.
I want to use GetRowMS to fetch a row from icsv1, muck it about, and add it to icsv2. Basically I'd rather write it this way rather that keep adjusting my tracking index on icsv1. A lazy "for" loop on icvs1 looping through all the rows.
int nr=sFileBuffer.RowCount int nc=sFileBuffer.ColumnCount
ICsv icsv2=CreateCsv() icsv2.Separator=","
???? declaration for multistring transfer row holder. Real variable decl WITHOUT using magical _s ????
int r c for r 0 nr ;;....... icsv1.GetRowMS(r ????multistring????) ;;....... icsv2.AddRowMS(-1 nc ????multistring????) ;;.......
Warning: The code possibly is invalid because some important characters (tabs, spaces) disappeared. Read more.
Thanks, -dana]]> Scenario: I want to reading a csv file into icsv1 then process each line, throwing some away, modifying others.
I want to use GetRowMS to fetch a row from icsv1, muck it about, and add it to icsv2. Basically I'd rather write it this way rather that keep adjusting my tracking index on icsv1. A lazy "for" loop on icvs1 looping through all the rows.
;???? declaration for multistring transfer row holder. Real variable decl WITHOUT using magical _s ???? str ms
int r c for r 0 nr ,;;....... ,icsv1.GetRowMS(r ms) ,;;....... ,icsv2.AddRowMS(-1 nc ms) ,;;.......
;results str s2; icsv2.ToString(s2);out s2
Reading/writing in multistring format is fast. But multistring format in most cases is inconvenient if you want to do something more with row data (read/change cells). Because all row cells are in single variable, and would need to parse it.
Here is example with array as a row holder. Macro ICsv row ARRAY?
;???? declaration for multistring transfer row holder. Real variable decl WITHOUT using magical _s ???? str ms
int r c for r 0 nr ,;;....... ,icsv1.GetRowMS(r ms) ,;;....... ,icsv2.AddRowMS(-1 nc ms) ,;;.......
;results str s2; icsv2.ToString(s2);out s2
Reading/writing in multistring format is fast. But multistring format in most cases is inconvenient if you want to do something more with row data (read/change cells). Because all row cells are in single variable, and would need to parse it.
Here is example with array as a row holder. Macro ICsv row ARRAY?
;???? declaration for multistring transfer row holder. Real variable decl WITHOUT using magical _s ???? ARRAY(str) a.create(nc)
int r c for r 0 nr ,;;....... ,for(c 0 nc) a[c]=icsv1.Cell(r c) ,;;....... ,icsv2.AddRowSA(-1 nc &a[0]) ,;;.......
;results str s2; icsv2.ToString(s2);out s2
]]>Programming :: Re: ICsv - GetRowMS - and multistring :: Reply by Dana2012-05-18T18:42:48+00:002012-05-18T18:42:48+00:00http://www.quickmacros.com/forum/viewtopic.php?f=4&t=5095#p23187Dana That's very helpful though now I can't find out what I was doing that was different. You know, sometimes you just can't see into the code after you've been starring at it long enough. Looking at your example has cleared up things in my mind and I can see my path forward.
-dana ]]> That's very helpful though now I can't find out what I was doing that was different. You know, sometimes you just can't see into the code after you've been starring at it long enough. Looking at your example has cleared up things in my mind and I can see my path forward.
]]>