I have a point layer with 900K Tree Point records. In that layer I have field (d_Species) that contains the tree species of each record. I've created a field (SpecieValu) to assign a value (0-3) for each record based upon the species of the tree point. There are hundreds of unique species and so I need to assign values based on a substring in the species field like "oak" or "cedar".
How do I use a wildcard search to find a substring and return a value?
My new field (SpecieValu) is a Double data type and the field I'm trying to reclass (d_Species) is a String data type. This is what I have so far but doesn't return anything but else 0: