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
Solved! Go to Solution.
Solved by plantech1. Go to 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' )