Hi We have a database which we would like to customize. First off here are the columns.
1. URL --> URL of a page
2. Filename --> filename of page that is in the URL.
What we would like is to have a code that can get the data from the URL field then cut the text to only show the filename.
so that the only thing that needs to be inserted are the URLs and it will automatically create the filename. I would prefer the code to be in the Query so that we can create a "Make Table" query out of it.