Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey there,
I'm trying to load from server some TXT files.
They have the same structure and file name, just change the end of the name by the date.
Example:
BigDataEmplGeral0908.txt
and
BigDataEmplGeral0909.txt
I'd like Loading all of them like:
BigDataEmplGeral*.txt
If I try to do it from a folder in my Desktop, I get, but I'm trying the same in server:
[http://public/public/BigDataEmplGeral*.txt] and It's giving error.
Someone?
What is the error that you are seeing?
The http protocol does not support wildcards like that. The same applies to the ftp protocol.They also do not support iteration with FileList().
If these are sharepoint files, try to access them from the network folder, rather than via sharepoint.
If they are web files, you will need to know the full file names. For FTP you can run an LS command and get the file list into a local file which you can then read. For http files, it depends on the web site.
Hi, Jonathan.
Tks for the answer.
In fact they are web files and I know the full name, but there is a new file every day.
The full name is BigDataEmplGeral + Date of creation+ .txt
If I understood what you said, I won't use "*" replacing the date and read all files in the web, will I?
If you know what the file name will be, you could do it dynamically something like this
Let vDate = Date(Today(), 'MMDD');
LOAD *
FROM http://public/public/BigDataEmplGeral$(VDate).txt
(txt, ....);
Adapt this to your exact requirements.