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

Mon, 05 Sep 2005 15:10:30 -0700

use <@crlf> instead.

-- 

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040

On Sep 5, 2005, at 12:19 PM, Quicknote wrote:

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: [email protected] 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

________________________________________________________________________



Roland A. Dumas
310 W. Bellevue Ave.
San Mateo, CA 94402
650-347-1373
415-412-9300 (cell)
AIM: radumas


________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to