Trimming charecters

[puthenveetil]

Hi all,

In my form I use browse option to select a file from directory.In the field it will like this c:\database\xxxx.jpg . This c:\database\ will be constant all time . I want only xxxx.jpg in the field. How can I cut off this c:\database while updating the record.


Thanks in advance

thankachan

 

[Mile-O]

If using A2000 or above then use the InStrRev() function to get the position of the last \ and then use the Right() to obtain only the file name without the path.

i.e.

Right([i]myData[/i], InStrRev([i]myData[/i], "\"))

 

[puthenveetil]

thanks SJ,

Pardon my ignorance, where could I use this code, afterupdate or ???

 

[Mile-O]

I don't know what controls you have in order to give the best answer although the form's BeforeUpdate event would, most likely, be best.

 

[puthenveetil]

thanks SJ

Thankachan

 

[puthenveetil]

SJ,

I can't make that work..I am attaching a sample db with this..If possible please add the code to that..

Thanks in advance


Thankachan

 

[Mile-O]

Example attached...

 

[puthenveetil]

SJ,

Thanks for the support

Thankachan