Hi team,
Can anybody suggest that how to fill null values in a string with spaces.
Example:
domain tcmcs.str10 string1,string2,string3
domain tcmcs.str50 result
string1="Happy"
string2="New"
string3="year"

result=string1&string2&string3

output is "Happy New year"

If there is no data in string1,string2 and string3 then spaces should be reserved with domain length,but it should not fill with NULL values.

Hi team,
Can anybody suggest that how to fill null values in a string with spaces.
Example:
domain tcmcs.str10 string1,string2,string3
domain tcmcs.str50 result
string1="Happy"
string2="New"
string3="year"

result=string1&string2&string3

output is "Happy New year"

If there is no data in string1,string2 and string3 then spaces should be reserved with domain length,but it should not fill with NULL values.

Hello,
your output is :

HappyNewYear

result = string1&" "&string2&" "&string3
will give the desired.

Maybe, declare the strings with "fixed"

Regards