RE: [MS_AccessPros] How do I truncate standard text?

 

Robin-

Perhaps an expression like:

Website: Mid([URL], Instr([URL], ".org.au/") + 8)

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Thursday, May 16, 2013 8:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How do I truncate standard text?

I have a report for the statistics from our website. The data is delivered
as a complete URL.

I need to show that part of the URL after our domain name.

Is it possible to show everything after .org.au/ ??

Many thanks,

Robin Chapple

------------------------------------

Yahoo! Groups Links

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 1
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___