I have a property "chaney_dell|Comments" from a joined database and I would like to use an expression like:
concat( "chaney_dell|Comments" ,'\P\', Tract_ID ,'\P', owner ,'\P', acres, ' ACRES' ,'\P', 'S-', sec ,' T-', twn ,' R-', rng ,'\P', book ,'/', page )
All I get is "text" as a label for my shape and when I go back to edit the expression it adds quotation marks to the beginning and end.
"concat( "chaney_dell|Comments" ,'\P\', Tract_ID ,'\P', owner ,'\P', acres, ' ACRES' ,'\P', 'S-', sec ,' T-', twn ,' R-', rng ,'\P', book ,'/', page )"
If I take the quotation marks off of chaney_dell|Comments it will not validate because of the | character. What am I missing here?
in one of your newline calls I see \P\ - with a second slash - does this affect anything?
I took it out but it still gets hung up on the | character. If I ever get this figured out the second \ would have definietly given me problems, thanks!
OK had a few moments to "Play" and I'm getting the same result. I'd say if you're on subscription open a support request and give it a higher priority, or take your chances to see if Nate & his fellow gurus respond here...
| is an "illegal character"?
do a calc and title the column without the |
for the calc select the property with the bar & OK. The data should be identical in both columns. Use the new column in the concat
Problem I found was that, at least in my C3D R2012 install, when I tried to style with an expression based on an expression and used "concat" then selected the field from the pull-down, a new line, and a piece of static text, I still just got "text" as the resulting label - not what I expected at all....
which is caused by the | in the joined column heading. I've had the same problem and solved it two ways, one as I explained and the other is mapimport and mapexport which changes the column from a join to part of the OD. One of the shortcomings of Map3d i guess.
Concur - it's funny that it would happen with an element put there by the software and not the user. seems par for the course with what we're given - "why use one step when 3 to 5+ just might get you there..."
When I try to do the calc that property does not show up? I have a data connection with a shp file and an ODBC excel file. When I view the table and go to create a calculation it only shows the shp file properties not the ODBC properties.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.