Populate observation

[deleted_user]

We have a requirement to populate an address field from database observation, please help.

The values will be extracted with more than one variable,
like VAR1 = #1C, RMG CAMPUS,
VAR2 = MG STREET,
VAR3 = TN.

Format should be like below:
Name Contact_no Address
Shan 999999999 #1C, RMG CAMPUS,\n
MG STREET,\n
TN.\n

[Olivier]

Check the CATX function, it may be a solution to your problem.
[pre]
address = CATX("\n", var1, var2, var3) ;
[/pre]