I'm playing around with the FEMA NFHL Database and have some text set up to provide the Flood Zone of the Polygon as shown below.
Now as you can see I'm getting an invalid expression, when I go to add the word Zone to the front of the data. Is there a way to do this?
Solved! Go to Solution.
Is there a way to do this?
I can definitely see I'm going to need a book or something for this - Anything you'd recomment?
CONCAT(First_Name, ‘ ‘Last_Name,’\P’ ‘Address: ‘, Street_number, ‘ ‘, Street_name, ‘ ‘, Suffix)
This example produces a label like this:
Address: 123 Maple Street
Try the help button and the getting Started at the bottom of the dialog for a few examples.
( Concat ( 'Cut Area No. ', CutAreaNo, '\P' ,(Concat ( 'Harvest Year is ' ,Year ))))
to get this
Cut Area No. 2
Harvest Year is 2013
' ' surround strings, add spaces here for neatness and readibility
Parenthesis work by the general rules of algebra, must have open and close pairs
commas seperate items
I use this for returning an empty string to a label if a street name in our road table (layer) is named 023.
If ( ' Street LIKE ''023'' ' , ' ', Street )
The if statement requires a string for the first parameter (go figure), so any true/false evaluation statement must have single quotes around it to get the if statement to work.
In the above example, Street is a text property of the road table (layer), Like is the comparison operator, 023 is the text to compare against.Then there is two single quotes, with a space between them, after the first comma to return an empty string (actually a single space) if the Street name is like 023. Finally there is Street after the second comma, which returns the text property Street if Street is not like 023.
Note the 023 is surrounded by two single quotes. This is what I have worked out is requred to get text to be evaluated within single quotes.
So for you try this.
CONCAT ( Owner_Name , '\P', Owne_Name_ , '\P', Mailing_Ad , '\P', Mailing__1 , '\P', Mailing_CS , '\P', PARCELNO )
Give this a try
CONCAT ( Owner_Name , '\P', If ( ' Not Owne_Name_ = '''' ', CONCAT ( Owne_Name_ , '\P'), ' ' ), Mailing_Ad , '\P', Mailing__1 , '\P', Mailing_CS , '\P', PARCELNO )
This should return the second owners name and a carriage return if the second owners name has a value otherwise it should return a space.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register