Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Help Comparing 2 Fields

 
   Database Help (Home) -> FileMaker RSS
Next:  Table Design  
Author Message
squeed2000

External


Since: Jan 16, 2005
Posts: 47



(Msg. 1) Posted: Fri Dec 26, 2008 1:08 pm
Post subject: Help Comparing 2 Fields
Archived from groups: comp>databases>filemaker (more info?)

I'm in them middle of developing an application that monitors a hand
full of web sites by comparing their content from one day to the
next. I'm using the Troi plug-in to capture the page content, and
bringing it into a text field.

I have 2 fields, TODAY's and YESTERDAY's before I get ready to move
the new content in, I move what was in TODAY to YESTERDAY and then I
bring in TODAY and do a simple If (TODAY = YESTERDAY) calculation.

That works fine for a majority of the sites that are being monitored.
However, today I found out that one of the new sites being added has a
stock ticker on it that gets updated daily. Since the ticker data is
not what needs to be monitored I don't care if that changes everyday,
except that it messes up my simple IF statement because now TODAY's
site does not match YESTERDAYS.

Each site monitored is different, what do you think the best possible
solution is to ignore the ticker changes ? I need to figure out a way
to add a tollerance to the if. Like if it's 90% the same, that's OK.
Is that possible ?

-S

 >> Stay informed about: Help Comparing 2 Fields 
Back to top
Login to vote
Your Name

External


Since: Nov 04, 2008
Posts: 25



(Msg. 2) Posted: Fri Dec 26, 2008 6:25 pm
Post subject: Re: Help Comparing 2 Fields [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

wrote in message

> I'm in them middle of developing an application that monitors a hand
> full of web sites by comparing their content from one day to the
> next. I'm using the Troi plug-in to capture the page content, and
> bringing it into a text field.
>
> I have 2 fields, TODAY's and YESTERDAY's before I get ready to move
> the new content in, I move what was in TODAY to YESTERDAY and then I
> bring in TODAY and do a simple If (TODAY = YESTERDAY) calculation.
>
> That works fine for a majority of the sites that are being monitored.
> However, today I found out that one of the new sites being added has a
> stock ticker on it that gets updated daily. Since the ticker data is
> not what needs to be monitored I don't care if that changes everyday,
> except that it messes up my simple IF statement because now TODAY's
> site does not match YESTERDAYS.
>
> Each site monitored is different, what do you think the best possible
> solution is to ignore the ticker changes ? I need to figure out a way
> to add a tollerance to the if. Like if it's 90% the same, that's OK.
> Is that possible ?
>
> -S

"Fuzzy" comparisons aren't possible in FileMaker. Even if it was possible,
how can FileMaker determine that the 10% that is different is or isn't what
you are interested in?

The only real way to achieve this would be to remove the "ticker" part of
the website from both Fields, but that would be very difficult unless there
is some way of determining where it starts and ends.

 >> Stay informed about: Help Comparing 2 Fields 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Calculation Field Comparing Calculation Fields? - Either FMP8 does not allow a Calculation Field to compare to another Calculation Field, or perhaps there is a nifty trick to do so? I've tried 'IF' and 'CASE' functions to no avail. Field 1 = TextA Field 2 = TextB Field 3 = Text C (This is actully..

? of fields - I have FMP 8.5 Advanced. Is is possible in Browse Mode, to have one field rely on another, what I am trying to achieve is if I have a field setup up as a numeric and I have another one setup as a text field. The text field will not be able to accept ....

Calculating fields - Hi, I,ve created a very simple solution using FM 8 on windows. It contains 1 table and a few fields. One of them is a date field and another a number field. The 3 field should be a total of all value's entered on all records in the number field, of the....

Repetition Fields - Version: Filemaker Pro adv 8.5 Platform: Mac OS I have been reading these forums regarding the repeat fields which seem to have a mixed reaction to their usage. For my purpose they seem to be an ok solution but there are some sticky points that maybe..

types of fields - New to FM editing db field names of file imported from txt files. The name of the fields are text, but I am unsure if in the Manage Data Base screen where the type of file is listed is it referring to the name which I am editing or if it means the conten...
   Database Help (Home) -> FileMaker All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]