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?
Rick Jackson
Survey CAD Technician VI
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Solved! Go to Solution.
Solved by Murph_Map. Go to Solution.
Thanks Murph,
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?
Rick Jackson
Survey CAD Technician VI
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
something like
CONCAT(First_Name, ‘ ‘Last_Name,’\P’ ‘Address: ‘, Street_number, ‘ ‘, Street_name, ‘ ‘, Suffix)
This example produces a label like this:
John Smith
Address: 123 Maple Street
Try the help button and the getting Started at the bottom of the dialog for a few examples.
Or this
( 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
Dave
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.
your expression
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.
Hi Murph, how would you make the expression center justified text.
My expression is: Concat (PID , '\n', NAME_1) and it displays
45
John Doe
I want it to display:
45
John Doe
Any help is appreciated.
Mike -
In the style label dialog there's a Horizontal Alignments button that lets you center the text.
I am running Civil3d 2011, my style label dialog box looks different than yours and the options for justification are grayed out.
Hello
YES it's normal because the FDO Engine is completely NEW in MAP/CIVIL 2012 !
They are many new features ...
Patrice BRAUD
Can't find what you're looking for? Ask the community or share your knowledge.