I have a calculation field that is suppose to search for a string within a
field, and assign a value if it finds it, otherwise assign another value.
CMycalField =
If (AdOrder = "*trk*", 2, 1)
Where the result is a number.
I was hoping to find the letters "trk" somewhere in the field and if found
assign 2 to CMycalField, if not assign 1. It assigns everything 1.
Can someone help clarify this for me
Thanks
|
|
0
|
|
|
|
Reply
|
 Henry
|
8/4/2003 10:19:29 PM |
|
Henry <henry_filemaker@hotmail.com> wrote:
> I have a calculation field that is suppose to search for a string within a
> field, and assign a value if it finds it, otherwise assign another value.
>
> CMycalField =
> If (AdOrder = "*trk*", 2, 1)
>
> Where the result is a number.
> I was hoping to find the letters "trk" somewhere in the field and if found
> assign 2 to CMycalField, if not assign 1. It assigns everything 1.
>
> Can someone help clarify this for me
If(Patterncount(Fieldname, "trk") = 1, 2, 1)
--
Lynn Allen Allen & Allen Semiotics
FSA Associate Filemaker Consulting & Training
lynn@semiotics.com http://www.semiotics.com
|
|
|
0
|
|
|
|
Reply
|
lynn
|
8/4/2003 10:29:56 PM
|
|
Lynn allen <lynn@NOT-semiotics.com> wrote:
> Henry <henry_filemaker@hotmail.com> wrote:
>
> > I have a calculation field that is suppose to search for a string within a
> > field, and assign a value if it finds it, otherwise assign another value.
> >
> > CMycalField =
> > If (AdOrder = "*trk*", 2, 1)
> >
> > Where the result is a number.
> > I was hoping to find the letters "trk" somewhere in the field and if found
> > assign 2 to CMycalField, if not assign 1. It assigns everything 1.
> >
> > Can someone help clarify this for me
>
> If(Patterncount(Fieldname, "trk") = 1, 2, 1)
What if there are multiple occurrences of the string "trk"?
If(PatternCount(Fieldname, "trk"), 2, 1)
--
Henk B
|
|
|
0
|
|
|
|
Reply
|
henk
|
8/4/2003 10:48:22 PM
|
|
|
2 Replies
191 Views
(page loaded in 0.034 seconds)
Similiar Articles: Need help with script/calculation - comp.databases.filemaker ...Here's the goal: Assume a layout with multiple fields. Go to the first field, extract both the contents of a field and the field name, concatenate t... Request for Help with Calculation - comp.databases.filemaker ...Calculation Field Help - comp.databases.filemaker Calculation Field Help - comp.databases.filemaker Need Help: FMPro calculations - Case & IsEmpty - comp ... Hourly labor rate change - need help with calculation - comp ...As of the new year, I've raised my hourly labor rate but I don't want the new calculation to effect previous years. The simple calculation I have for the field now is ... Calculation Order ?? - comp.text.pdfCalculation Field Help - comp.databases.filemaker... assign a value if it finds it ... Go to the first field, extract both the contents of a ... Calculation Order ... Calculated fields - Storing them or not, forcing them to calculate ...I cannot help you but am interested in a solution. Michael Paine ... A calculation field can't have anything entered into it. It is always the result of the ... Changing a calculation field to values? - comp.databases.filemaker ...Hourly labor rate change - need help with calculation - comp ... Changing a calculation field to values? - comp.databases.filemaker ... Calculation Field Help - comp ... Date Range Calculation - comp.databases.filemaker(The calculation of age is working fine.) I then need to calculate a further field ... ... Request for Help with Calculation - comp.databases.filemaker ... Date Range ... INSERT PICTURE INTO A CONTAINER FIELD DYNAMICALLY - comp.databases ...If you're in FMP7, look at "Defining File References" in Help. Specify a calculation field containing "image:/C:/Path/To/File.jpg" (or other supported format) either ... quick problem - parsing text, calculation function... - comp ...If you can help me with this one problem I will then be able to write the entire calculation. In another field called name, I want to parse through the email looking for ... finding in a portal? - comp.databases.filemakerThis means some trickery needs to go on via scripts and / or Calculation fields. Multi-keys can sometimes help, but it depends exactly what you're trying to achieve. Desktop Help 10.0 - Calculate Field (Data Management)Summary. Calculates the values of a field for a feature class, feature layer, or raster catalog. View examples of using Calculate Field Calculate Field (Data Management) - Esri - The GIS Software Leader ...Calculates the values of a field for a feature class, feature layer, or raster catalog. The input table will be modified; a copy should be made to preserve the ... 7/19/2012 7:27:27 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
15 followers. 