conditional trim?

[qwkslvr1999]

I have a field that displays url in a report like this: http://www.webaite.com/personal/page_title.jsp

In some records, this field tend to be very long. I am just wondering if the URLs can be trimmed without editing each one. Is there a way that would tell Access to show only a part of text until it reaches .com and disregard the rest of the URL?

Thanks!

 

[Newman]

You could use the InStr function...

But what about .ca .uk .info ...?

Newman

 

[qwkslvr1999]

Thanks for the idea. I just used the .com as an example. Maybe once I make it work with .com, I can do something to make it work with the others too.

 

[Newman]

I am not realy sure how the InStr works, so I better left this to someone else...
Also there may be some problems with some URLs.
What about this:
http://www.COMputers.com

Sorry to point this!

Newman

 

[qwkslvr1999]

You know, you are right! But then I decided to just stop worrying about it. My users are fine with the long urls (anyway, they were the ones who decided to do it that way earlier ) I just thought of it since they kind of realized that the report doesn't exactly look nice with the verrry long urls. I guess, they just have to live with it for now.