[ic] Export Specific Columns and Rows

Jon interchange-users@icdevgroup.org
Thu Oct 24 08:46:01 2002


Mike Heins wrote:

> Quoting Jon (prtyof5@attglobal.net):
> >     Can someone provide a sample code snippet to export specific
> > rows and specific columns from a table. I've read about the export tag
> > which appears to assume you want to export the entire table; all rows
> > and columns.
> > And I've searched the archives for which there is a lot of discussion
> > but I didn't find what I'm looking for there either.  An example would
> > be real helpful.   Thanks !
> >
>
> If it doesn't have embedded tabs, something like this would work:
>
> [log type=text file=">output.txt" interpolate=1][loop search="
>                         sf=prod_group
>                         se=Hand Tools
>                         rf=sku,price,description
>                         "
> ][loop-line]
> [/loop][/log]
>

    Well, what I'm looking to do is take the transaction table to create
a specific probably CSV type file to use for importing.  I like what the
export
function in the admin UI does except it dumps all rows and columns.
Would the above example place commas between fields ? Thanks Mike.

Jon