I'm iterating through a collection of child object records and grabbing the values of 3 different fields and I'm adding them to one field on the Master (Asset Roll-up). As I assign the child object's values, I add a semi-colon as a separator. I assign them to a variable in the Flow, then assign them to the SObject variable and Update it to the actual field in Salesforce. When I do, I get an extra semi-colon for each blank value, because each field needs a semi-colon after each value.
Parent Object = Parent Object, Field = Asset Rollup. Child Object = Child Object, Fields = Asset Name, Other Asset Name, Archived Asset Name.
Record 1: Asset Name = "Carrots". Asset Other Name = blank. Archived Asset Name = blank.
Record 2: Asset Name = "Peas". Asset Other Name = blank. Archived Asset Name = blank.
Record 3: Asset Name = "Potatoes" Asset Other Name = "Spuds", Archived Asset Name = blank. Asset Roll-up: "Carrots;;Peas;;Potatoes;Spuds;"
If I remove the semi-colon, the values have no separator. I've even created 3 new fields, one for each field from the Child object and used a workflow rule to populate the values and am still getting the extra semi-colons.
I can provide screen shots.