Home » Developer & Programmer » Forms » How to use Pattern matching in Text_IO package (Forms 6i,Win xp)
How to use Pattern matching in Text_IO package [message #440370] Fri, 22 January 2010 23:32 Go to next message
sharathmpatil
Messages: 38
Registered: February 2008
Location: Bangalore
Member

Dear All,

I have a requirement which is as follows.A file will be downloaded into a server every day at 2 A.M. The name of the file would be 'BB90170_sysdate_D'. I need to refer to this file everyday since everyday the data changes.How do i identify which is the latest file in the server folder using Forms 6i code.
Means while i have tried this
'' in_file :=Text_IO.Fopen ('C:\TIES\Partprocurement\BB90170_'||part_date,'r')". How to use pattern matching in Text_io.fopen. Part_date in refers to sysdate without Timestamp.

Please help on this

Thanks in advance.
Re: How to use Pattern matching in Text_IO package [message #440377 is a reply to message #440370] Sat, 23 January 2010 01:13 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
in_file :=Text_IO.Fopen ('C:\TIES\Partprocurement\BB90170_'||part_date,'r')"


in_file :=Text_IO.Fopen (file_location||\||file_name||file_ext,'r');

For Ex:
in_file:=Text_IO.Fopen('C:\temp'||'/'||'abc.txt','r');
Re: How to use Pattern matching in Text_IO package [message #440378 is a reply to message #440377] Sat, 23 January 2010 01:14 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member

path separator will be for windows: '\'
in_file:=Text_IO.Fopen('C:\temp'||'\'||'abc.txt','r');
Re: How to use Pattern matching in Text_IO package [message #445088 is a reply to message #440370] Thu, 25 February 2010 18:41 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

Consider using 'host' or 'client_host' to perform a command similar to 'dir > dir_list.txt', then read the 'txt' file to ascertain which files are available.

David
Previous Topic: oracle form entry
Next Topic: How to get current cursor postion in oracle 10g form
Goto Forum:
  


Current Time: Mon Sep 26 09:25:19 CDT 2016

Total time taken to generate the page: 0.09401 seconds