Save Report using tab delimited fields instead of just comma (OpenInsight 64-bit)
At 20 NOV 2023 02:41:34PM BrianWick wrote:
Hi -
10.2
Reports are great improvemnt tx.
It would be nice to save reports as a Tab Delimited ASCII file where it looks like the Comma delimited is the only option now ?
It saves a reduntant step.I find Tabs are much cleaner
Tx'Bri
At 20 NOV 2023 02:54PM bob carten wrote:
You can export the data from a report using rlist. The =rlist]wiki for rlist describes how to use target_variable$ ( or 2) to execute an rlist command to a file
* Export Tab delimited data $insert rlist_equates declare subroutine Rlist cmd = 'LIST MYTABLE COL1 COL2 COL3 WITH MYCOLUMN="SOMEVALUE"' exportFile = "c:\temp\myfile.txt" userArg= "":@fm:"TXT" ;* Format is passed via userarg<2> RList(cmd, TARGET_OSFILE$, exportFile , userarg)
At 20 NOV 2023 03:11PM BrianWick wrote:
tx bob.
If i am doing the same report from the TCL command I do not see that Tab Delimited TXT as a format to choose from ?
tx
Bri
At 20 NOV 2023 03:40PM bob carten wrote:
Try TXTFILE instead of CSVFILE
LIST 10 PERSON LNAME FNAME TXTFILE 'c:\temp\test.txt'
At 20 NOV 2023 03:59PM BrianWick wrote:
As usual Bob -
Very cool stuff…..
tx for chimming in.
Bri
At 21 NOV 2023 03:47AM Andrew McAuley wrote:
Unless something has changed then it should support
"CSVFILE"
"DHTMLFILE"
"DHTMLPAGE"
"HTMLFILE"
"HTMLPAGE"
"OIPIFILE"
"RTFFILE"
"PDFFILE"
"TXTFILE"
:)
World leaders in all things RevSoft