RE: [sqr-users] Check if File Exist

["Pactwa, Marissa" <mpactwa@suburbanpropane.com>]

Ok. What if I need to be able to read the file from my SQR program and
process? Is there a way to pass back the actual filename.

Thanks so much. 
Marissa

-----Original Message-----
From: sqr-users-bounces+mpactwa=suburbanpropane.com@sqrug.org
[mailto:sqr-users-bounces+mpactwa=suburbanpropane.com@sqrug.org] On
Behalf Of Putney II, Zynon E
Sent: Wednesday, April 16, 2008 10:48 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Check if File Exist

Maybe something like this? Assuming Unix. Replace THING with whatever

you're trying to find.

Display #status to make sure it's returning 1 or 0 when appropriate.

Might be way off with this though.



Let $chk_dir = 'ls | grep THING'

Call system using $chk_dir #status

If #status = 1 

     ...

End-if

If #status = 0

   ....

End-if





======================

Thank you,



Zynon E. Putney II

Software Developer





-----Original Message-----

From: sqr-users-bounces+zputney=paychex.com@sqrug.org

[mailto:sqr-users-bounces+zputney=paychex.com@sqrug.org] On Behalf Of

Pactwa, Marissa

Sent: Wednesday, April 16, 2008 10:38 AM

To: sqr-users@sqrug.org

Subject: [sqr-users] Check if File Exist



Hi All,



 



I need to write a code that would check if any file that begins with a

certain word exist in the network folder. Is there any command in SQR to

do this? Unfortunately, it will not always be a date stamp that will

make the filename variable.



 



For example, 



            Test_file_030108.txt



            Test_file_031508a.txt



 



Thanks in advance.



Marissa



 



 



 



_______________________________________________

sqr-users mailing list

sqr-users@sqrug.org

http://www.sqrug.org/mailman/listinfo/sqr-users





-----------------------------------------

The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer. 



Thank you. Paychex, Inc.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users