Text Expression Error??

[cloquet]

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

[plantech1 · Accepted solution]

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' )