friday I came across a small problem.
My source file has 4 columns containing address information.
I would like to concatenate them separated by comma and have done so in the expression editor for modify columns action.
Unfortunately this sometimes might result in poor looking results because sometimes some adresses are shorter.
OK: Street, Building, Postcode and place, Country
Not OK: Street, , ,
Means: Sometime there are addresses which do not have all information; if I just concatenate like [column1]&", "&[column2] then sometimes I will get resulting entries like above: Empty fields followed by comma space.
Is there any possibility to insert the comma space only is the field is not empty?