AutoCAD Map 3D

[#1]

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?

[#2]

in one of your newline calls I see \P\ - with a second slash - does this affect anything?

[#3]

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!

[#4]

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...

[#5]

| 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

Dave

[#6]

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....

[#7]

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. 

[#8]

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..."

[#9]

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.

[#10]

do you try  display manager   select the layer r clk and select refresh layer?