Selasa, 25 Juni 2013

RE: [MS_AccessPros] How do I truncate a URL

 

Yes this can be done with string/text functions like:
- Instr() to find text within a string
- Left()
- Right()
- Mid()
- InstrRev()

There are descriptions and examples in Help and all over the web.

Duane Hookom MVP
MS Access

----------------------------------------
> From: robinski@mymail.net.au
>
> I have a query that records visitors to our web pages. It includes
> the domain name for each and every line which is both very space
> consuming and very poor visually.
>
> Is there any way that I can show the URL without the domain name?
>
> Many thanks,
>
> Robin Chapple

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar