Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Distinguished Contributor
cloquet
Posts: 108
Registered: ‎09-06-2006
Message 1 of 2 (1,246 Views)
Accepted Solution

Text Expression Error??

1246 Views, 1 Replies
06-07-2011 07:08 AM

I'm having trouble understanding the Text Expressions.

This Expression works as follows:

 

CONCAT ( CONCAT ( CONCAT ( CONCAT ( PARCEL_NUM , '\n' ), Owner_Name ), Prop_Add1 ), Prop_Add2 )

 

But then I want to add and enter after each field, so i put in this Expression but i get an error saying the number of arguments for function is invalid:

 

CONCAT ( CONCAT ( CONCAT ( CONCAT ( PARCEL_NUM, '\n'),  Owner_Name , '\n' ), Prop_Add1 , '\n' ), Prop_Add2 , '\n' )

 

Any help would be appreciated.

Thanks

 

 

 

 

You need to concatenate each '\n' entry just like the first inside CONCAT with (PARCEL_NUM, '\n').  Each entry needs to be concatenated with the previous concatenation.  Try adding three more CONCATs like:

 

CONCAT ( CONCAT ( CONCAT ( CONCAT ( CONCAT ( CONCAT ( CONCAT ( PARCEL_NUM, '\n'),  Owner_Name ), '\n' ), Prop_Add1) , '\n' ), Prop_Add2) , '\n' )

Active Member
jerryr
Posts: 9
Registered: ‎12-22-2006
Message 2 of 2 (1,228 Views)

Re: Text Expression Error??

06-09-2011 05:55 AM in reply to: cloquet

You need to concatenate each '\n' entry just like the first inside CONCAT with (PARCEL_NUM, '\n').  Each entry needs to be concatenated with the previous concatenation.  Try adding three more CONCATs like:

 

CONCAT ( CONCAT ( CONCAT ( CONCAT ( CONCAT ( CONCAT ( CONCAT ( PARCEL_NUM, '\n'),  Owner_Name ), '\n' ), Prop_Add1) , '\n' ), Prop_Add2) , '\n' )

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.