OraFAQ Forum: Forms » How to use Pattern matching in Text

Home » Developer & Programmer » Forms » How to use Pattern matching in Text_IO package (Forms 6i,Win xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to use Pattern matching in Text_IO package [message #440370]

Fri, 22 January 2010 23:32

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.

Report message to a moderator

Re: How to use Pattern matching in Text_IO package [message #440377 is a reply to message #440370]

Sat, 23 January 2010 01:13

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');

Report message to a moderator

Re: How to use Pattern matching in Text_IO package [message #440378 is a reply to message #440377]

Sat, 23 January 2010 01:14

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');

Report message to a moderator

Re: How to use Pattern matching in Text_IO package [message #445088 is a reply to message #440370]

Thu, 25 February 2010 18:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:21:54 CDT 2024