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?