Jump to content

Identify records based on an URL?


This topic is 2865 days old. Please don't post here. Open a new topic instead.

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!

Link to comment
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
Link to comment
Share on other sites

This topic is 2865 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

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