OK so the solution is not necessarily* a "Clarity solution" if all you need to do is put some data from a file into a database table - and there are many ways of doing that, I would suggest that the best way for you to do it would be whichever technical way you (or your organisation) are most comfortable with or capable of.
(* for example you could build a locally running routine on your sever that looks for files and uploads the contents of that file to a database table - no "Clarity" involved there)
Other considerations you might have are whether this is a one-off process or a regular interface (and if regular, how regular - for example if its "once a month" you might choose a manual or semi-manual process, if it is "several times every day" you would expect a fully automated process).
Original Message:
Sent: 10-01-2019 09:55 AM
From: Vinay Bhushan
Subject: Read two files in a directory with same names and one having timestamp
There are few files in other interface. We import those files which have the data .That data is needed to be read and should be inserted into an intermediate table
Original Message:
Sent: 10-01-2019 09:22 AM
From: David Morton
Subject: Read two files in a directory with same names and one having timestamp
I think you will need to describe what you want to do with the files / what are the files / what does it have to do with your Clarity system and so on...
Original Message:
Sent: 10-01-2019 06:58 AM
From: Vinay Bhushan
Subject: Read two files in a directory with same names and one having timestamp
Hi ,
I would like to read two files in a directory with nearly same names where one has timestamp included in the name.
Eg: File 1: Magic2PPM
File 2 : Magic2PPM_ddmmyyy
Please advice me how to read files like these.
Regards,
Vinay