vb right function

aneilg,

Please elaborate on what you are trying to do.

Patrick

Not sure what your question is?

Are you trying to figure out how to locate the "new" file, based on looking for just FREDDY?

Or are you asking how to extract the FREDDY from the file name that will change each day?

~bp

can you please clarify the issue?
do you need the 00001 part "set" into the string, or extracted from the string?
aka where does which value come from?

if you want to "set" the value, you might do something like this:

dim strFile 
strFile = "\\server\Renewal_Date_Capture\RDCDATA$$$$$$FREDDY.dat"
strFile = replace(strFile, "$$$$$$", right( "000000" & your_number , 6 )) 
load_success=Process_Claims_File (strFile, myClaims_Journal) 

Select allOpen in new window

hope this helps

Sorry, I dont really understand the question, can you try again?

In general, the Right function will return the rightmost characters of a string.  eg wscript.echo  Right("ThisIsAnExample",3)  will produce "ple"

The Left function will do similar on the leftmost characters.  eg wscript.echo  Left("ThisIsAnExample",3) will produce "Thi"

Perhaps you want the leftmost characters excluding the rightmost 6 (for FREDDY) and 4 (for .dat)?

If so, Left(strYourVarilable,Len(strYourVariable)-10) should produce that.

Still not sure what you are going to do with that though?

hello sorry.
i just need to Identify the file name from freddy.
the location will always be the same.

so if the file is ("\\server\Renewal_Date_Capture\RDCDATA000001FREDDY.dat", myClaims_Journal)
i know i nedd to process file freddy.

or if the file is ("\\server\Renewal_Date_Capture\RDCDATA000001abcdef.dat", myClaims_Journal)
i know i nedd to process file abcdef.

How about this:

strFile = "\\server\Renewal_Date_Capture\RDCDATA000001abcdef.dat"
strPiece = Right(Left(strFile, Len(strFile)-4), 6)

Select allOpen in new window

~bp

thanks.

sorry guys my mistake.

basically what i want to do is read a file from a path.
 ("\\server\Renewal_Date_Capture\RDCDATA000001FREDDY.dat", myClaims_Journal)

i want to take out RDCDATA000001FREDDY.dat and use that file name.

So, are you saying that there is a file in a folder that you want to use and that it has a name that you don't know but it will end in FREDDY.dat?

Sorry for the confusion guys.

What I want to do is just get the .dat file name, irrespective of what the file is called.
I want to get the name of the .dat file from the folder.

on my folder, the faile name can be anything.
("\\server\Renewal_Date_Capture\RDCDATA000001FREDDY.dat", myClaims_Journal)

or
("\\server\Renewal_Date_Capture\RDCDATA000001PAUL.dat", myClaims_Journal)

i need to get the .dat file name.

Okay, we are getting somewhere.

Is the path and partial filename always the same?

Path is always \\server\Renewal_Date_Capture?
File name always starts with RDCDATA000001?
File name always ends with .dat?

Will there be many files in this folder when the script runs or just one?

thanks for your help alan.

the folder will always be the same.
the file will NOT start with RDCDATA000001.
the file will always end in .dat.

so i need the name of the full .dat file to use.

And there will only be one .dat file in the folder when you run the script?

thanks alan.

really do Appreciate your help.

fandabidozi