Jump to content
Sign in to follow this  

Identify records based on an URL?

Recommended Posts



For my bachelor thesis i have a rather large dataset which i have chosen to arrange and "clean" in filemaker, before further analysis.


The data origins from a forum, with 36.000 topic replies, including the topic starter itself, in the same form as the replies.


I've found out how to separate topic starters from the others, via a dummy variable, returning 0 if topic text has RE: as the first 3 chars, and 1 if not.

However, as my data seem to have been damaged, I have a lot of empty topic fields, but with the original URL, looking like this:


The first f=1 is the ID of the subforum the entire dataset is taken from, and the &t=63898 is ID of the topic. The last two must be page#, but i am actually not sure of that.


However, is it possible to make a calculation, using one of the text functions in Filemaker, to get the value of the &t=63898 ?

First off, i would have used Left / Right functions, but the number of digits varies from 4 to 6, which makes it very complicated...


Is there some sort of search function that returns everything between "&t=" and "&p=" or in some of the cases nothing at the end..




Any help will be much appreciated!

Share this post

Link to post
Share on other sites

Try =

Let ( [
text = OriginalURL & "&" ;
pos = Position ( text ; "&t=" ; 1 ; 1 ) ;
start = pos + 3 ;
end = Position ( text ; "&" ; start ; 1 )
] ;
Case ( pos ; Middle ( text ; start ; end - start ) )

This extracts the text between "&t=" (if it exists) and the subsequent "&", if any (otherwise until the end of the OriginalURL text).

  • Like 1

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.