Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

fnALSourceParse ( source ; attribute )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 4.1  (39 votes)
  Discuss this Custom Function

Jeremy Upton, DME Supply Group
http://www.dmesupplygroup.com

Returns a list of values for the supplied attribute from the source code of a webpage. See - fnHTMLAttributeList

Sample Input:
fnALSourceParse ( "\source code of http://www.briandunning com" ; 'href" )
Sample Output:
http://www.briandunning.com/
http://www.briandunning.com/consulting/ventures.php
http://www.briandunning.com/tomarket/
http://www.briandunning.com/filemaker-pro/
http://www.briandunning.com/filemaker-custom-functions/
http://www.briandunning.com/filemaker-web-viewer/
http://www.briandunning.com/consulting/
http://www.briandunning.com/training.shtml
http://www.briandunning.com/books.shtml
http://www.briandunning.com/magazines/
http://www.briandunning.com/error-codes/?source=FileMaker
http://www.briandunning.com/free-web-tools/
http://www.briandunning.com/free-filemaker-tools/
http://www.briandunning.com/personal.shtml
http://www.briandunning.com/videos/
http://www.briandunning.com/adventures/
http://www.briandunning.com/links/
etc... (not showing complete results)


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

NOTICE: This function is intended to be used in conjunction with the custom function - fnHTMLAttributeList available from www.briandunning.com. It makes things much easier, however it does not require it.

This function does a simple thing. It takes the source code provided and locates every occurrence of the text (attribute) that you request. It then returns the next value within quotes (" ") following each of those occurrences in a list format. You can literally type anything for the attribute parameter, but the function really becomes useful when you enter html attributes. Here are some examples:

Entering "src" can be used to get a list of images on page.
Entering "href" will produce a fairly complete list of links on the page. As seen in the sample output.

Information like this can come in very handy for tasks like web scraping.

In my testing I found that the usefulness of the results depended greatly on the how the site was organized. For instance, a page that utilizes a lot of javascript will not produce much that you can use. However, you can fine tune the string that you want the function to look for and often times get better results. For example, entering "<a href" will usually produce a more relaible list of links than simply using "href". It's not perfect but it provides a great starting point.

If anyone out there with more knowledge of html than myself knows how this can be improved I welcome your input.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

How would you modify this if the attribute string itself has quotation marks? I don't want all the href links from my site, just the ones that are preceded by '<a class="cssa" href='

Mark Keedy, Kenosha, Wisc.
September 12, 2013 9:21am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 1 + 1 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions