RE: Witango-Talk: FW: Export to Text File

[Quicknote]

Hi Roland Thanks for the advice about the Direct to DataBase action. My array has a lot of columns and I did not want to hard code with <@COL num=1> etc. SO I used ************* <@VAR a_lineitems[*,*] SCOPE=Local APREFIX='start' ASUFFIX='end' RPREFIX='<@CHAR CODE="13">' RSUFFIX='|' CPREFIX=' ' CSUFFIX=','>   This works except the <@CHAR CODE="13"> is not creating a line break?   Thanks again Janet -----Original Message----- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Monday, September 05, 2005 1:54 PM To: witango-talk@witango.com List Cc: Quicknote Subject: Re: Witango-Talk: FW: Export to Text File well, if you want to export to excel, a table format is just what the doctor ordered. If you want to export to a text, say a .csv file, it's simple, but different. You'd create a new variable and dump the content of your resultset into it in .csv format. it would look something like: <@ASSIGN request$csv value=" <@ROWS> <@COL num=1>,<@col num=2>,...<@COL NUM=n>; </@ROWS> "> If you want it to write on the server side, then you just use a write action. If you want it to download to the client, then you'd follow the same path as you did for the excel, but changing the extension and the application association, etc. On Sep 4, 2005, at 5:39 PM, Quicknote wrote: -----Original Message----- From: Quicknote [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 04, 2005 8:10 PM To: WiTango List Subject: FW: Export to Text File -----Original Message----- From: Quicknote [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 30, 2005 9:31 PM To: WiTango List Subject: FW: Export to Text File I made (2) File Actions to export a resultset 1) to excel worked great 2) to TEXT file - I can't get rid of the HTML Table formattting I tried ENCODING=NONE Here is what I am trying but still all the HTML formatting is included? I assigned the resultste = a_lineItems <@ARRAY ROWS="<@NUMROWS ARRAY='a_lineItems'>" COLS="<@NUMCOLS ARRAY='a_lineItems'>" VALUE="<@VAR a_lineItems[*,*] SCOPE=Local ENCODING=NONE>" [CDELIM=,] [RDELIM=||]> Thanks Janet ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf Roland A. Dumas 310 W. Bellevue Ave. San Mateo, CA 94402 650-347-1373 415-412-9300 (cell) AIM: radumas [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf