strip off data from a field

[puthenveetil]

HI all,

I had a field which is populated by selecting file from filebrowser. In that I am able to get the file and it is entering to field correctly also. The result will be like this.

\\server\database\2005\649937\xxxxxx.jpg

Is there any way to rip off \\server\database\2005\649937\ .jpg
this is area from that field...

The point is that I had to confirm that the xxxxxx is same with the field which I had in my form


thanks in advance

thanks

 

[namliam]

Use dir...

The result of Dir("\\server\database\2005\649937\xxxxxx.jpg"), if the file exists, will be xxxxxx.jpg

Greetz

 

[puthenveetil]

Namliam,

That was great, thanks. If you don't mind, how can I remove .jpg from xxxxx.jpg.

Thanks again

thanks

 

[namliam]

Left(dir(...),len(dir(...))-4)

or offcourse

variable = dir(...)
Left(variable,len(variable)-4)

 

[puthenveetil]

Mailman,

Great, thank you once again........



Thanks