Hi all,
I’m trying to export a report from the data manager. The catch is that I want it in a format that DOESN’T tab, space, or comma the data in anyway because thats how our DB2 database reads it. Or even if there is a script that can do this, but I haven’t found the function. Thanks much all.
Neil Buranakanchana
SPS PAYMENT SYSTEMS
Listserv Archives (BOB member since 2002-06-25)
Neil,
You must have at least a space between the data else you’ll only get a single row if info. You could export it to a text file and then do a global search the delimiting character or space and replacing it with nothing using Wordpad.
Is exporting it directly to the database an option? That way BusinessObjects would put it up there for you … though you would still have to move it to the appropriate table.
If not and the only option is via script:
’ Brief Sendkeys/ConvertTo Example
’ Author: Jim Droppa Source Consulting
’ Created 11/11/1998
’
’ Copyright 1998
SUB main
DIM dp AS BODataProvider
DIM WordPadPath AS STRING
WordPadPath = “C:\Program Files\Accessories\wordpad.exe C:\BusinessObjects\UserDocs\SQL1.csv”
set dp = ActiveDocument.DataProviders.Item(1)
call dp.ConvertTo(ExpAsciiCSV,1,“SQL1.csv”)
x = Shell(WordPadPath,1)
SendKeys “%Ee;%a” ,1
’ Wait until the replace is done.
’ May be too long but want to make sure. For t=1 to 100000 step 1
NEXT t
SendKeys “{ENTER}” ,1
’ Wait until the OK prompt window is gone ’ Shouldn’t needed it but for some reason ’ I did in this case.
For t=1 to 100000 step 1
NEXT t
Sendkeys “{TAB}%o%FS%FX” , 1
END SUB
You may have to tweak the sendkeys and change to
your WordPad location.
The write statement is another ReportScript option.
Jim Droppa
Source Consulting
========================================== On Wed, 11 Nov 1998 12:44:54 -0500, Neil Buranakanchana wrote:
Hi all,
I’m trying to export a report from the data manager. The catch is that I want it in a format that DOESN’T tab, space, or comma the data in anyway because thats how our DB2 database reads it. Or even if there is a script that can do this, but I haven’t found the function. Thanks much all.
Neil Buranakanchana
SPS PAYMENT SYSTEMS
_______________________________________________________ Get your free, private e-mail at http://mail.excite.com/
Listserv Archives (BOB member since 2002-06-25)