Help with basic calculation field

Discussion created by raykennedy on Apr 29, 2012
Latest reply on Apr 30, 2012 by digital-carpentry

I know a couple other programming languages and still trying to grasp filemaker. This is probably a simple question but I haven't had much luck with it.


Here is what I am trying to do. I DB I created and I added a field specifically as a calculation for the purpose of creating another way to flag of categorize the data for static searchs at a later date. When I import data into my table there is content that is pulled into decription. I have a separate calculation field that searches for certain keywords in the description field and if it finds them than it puts a certain flag or keyword in the calculation field.


Here is how I envision the code:


If(description LIKE %ABC%; "123", 0);


So basically if the field description has the content "ABC" than it will input "123" in the new calculation field.


I hope that makes sense. Any ideas on how to approach this?