The truth is, I did not have too much time to fix it and the matter was slightly urgent. So all I did was, after I dump the data to a temp file, I run it through a FOR /F loop which in one line filters the columns I need and then writes them to the final nice looking csv file. :) When I have more time I will look into it and let you know if I manage to fix it. Thanks for your assistance :) frex
--- En date de : Ven 28.11.08, Kaïs Albassir <[EMAIL PROTECTED]> a écrit : De: Kaïs Albassir <[EMAIL PROTECTED]> Objet: Re: RUNMACRO À: [email protected] Date: Vendredi 28 Novembre 2008, 12h28 Hi Frex, May you send us your macro and the definition (.def file) of the form you want to extract data from. We shall see what we can do for you Visit www.arsmarts.com and discover a brand new third party product to enhance your productivity > ** > > Hello all, > > ARS: 7.1 patch04 > > I am using the runmacro to dump some data from a form. All done in a > batch script which I run from the command line. > > The following command does more or less what I want. > > %ARDIR%runmacro.exe" -x %ARSVR% -U %ARUSER% -P %ARPASS% -a %ARPORT% > -o %TARGDIR%%TARGFILE% -f %ARFORM% -t csv -q "'1000000161' != $NULL$ > AND '7' = "0" > Now I am trying to change this to extract only certain columns from > the form. I have tried to do this by going to the user tool switch the > macro button, run a search, then generate a report skeleton and write > the data to some file. However, I want to be able to write to the file > specified by -o rather than the file specified within the macro. There > are other issues also when copying the script to a different machine > etc etc.. > > My question is, is there a way I can edit a file (.arq) manually and > tell it to dump columnA and colunB from a particular form etc and then > include the -e option in the command above? Rather than having to go > to the user tool and create everything from there!!! > anywayone has done this and wants to share his macro? > > Thanks in advance > frex > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > Are" html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
