Quick Macros Forum

Quick Macros Forum http://www.quickmacros.com/forum/smartfeed.php?feed_type=RSS2.0&limit=1%20DAY&sort_by=standard&feed_style=HTML&max_word_size=All Fri, 18 May 2012 10:58:36 -0400 phpBB 3 SmartFeed Modification 2.0.RC3 (mark@phpbbservices.com) (info@mypapit.net) http://www.quickmacros.com/forum/styles/prosilver/imageset/site_logo.gif Quick Macros Forum http://www.quickmacros.com/forum/smartfeed.php?feed_type=RSS2.0&limit=1%20DAY&sort_by=standard&feed_style=HTML&max_word_size=All en-US Fri, 18 May 2012 14:58:36 -0400 60 Programming :: ICsv - GetRowMS - and multistring http://www.quickmacros.com/forum/viewtopic.php?f=4&t=5095#p23185
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.

???? marks where I need help.

Code: Select all: ICsv icsv1=CreateCsv() icsv1.Separator="," icsv1.FromFile("C:\testdata.txt") 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]]> no_email@example.com (Dana) Programming http://www.quickmacros.com/forum/posting.php?mode=reply&f=4&t=5095 Thu, 17 May 2012 17:09:46 -0400 http://www.quickmacros.com/forum/viewtopic.php?f=4&t=5095#p23185 Programming :: Re: ICsv - GetRowMS - and multistring :: Reply by Gintaras http://www.quickmacros.com/forum/viewtopic.php?f=4&t=5095#p23186 ICsv row str ?

ICsv icsv1=CreateCsv(1)
str s1=
;a1,b1,c1
;a2,b2,c2
;a3,b3,c3
icsv1.FromString(s1)

int nr=icsv1.RowCount
int nc=icsv1.ColumnCount

ICsv icsv2=CreateCsv(1)

;???? 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 ?

ICsv icsv1=CreateCsv(1)
str s1=
;a1,b1,c1
;a2,b2,c2
;a3,b3,c3
icsv1.FromString(s1)

int nr=icsv1.RowCount
int nc=icsv1.ColumnCount

ICsv icsv2=CreateCsv(1)

;???? 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

]]> no_email@example.com (Gintaras) Programming http://www.quickmacros.com/forum/posting.php?mode=reply&f=4&t=5095 Fri, 18 May 2012 00:43:16 -0400 http://www.quickmacros.com/forum/viewtopic.php?f=4&t=5095#p23186 Programming :: Re: ICsv - GetRowMS - and multistring :: Reply by Dana http://www.quickmacros.com/forum/viewtopic.php?f=4&t=5095#p23187
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

]]> no_email@example.com (Dana) Programming http://www.quickmacros.com/forum/posting.php?mode=reply&f=4&t=5095 Fri, 18 May 2012 14:42:48 -0400 http://www.quickmacros.com/forum/viewtopic.php?f=4&t=5095#p23187