Help! Is there a way to change the concatenate from a comma to a hard return?
S

I have a trigger to copy all the items from a sub-table ('Item Desc" into a multiline field ('LongDescription'),

LongDescription := concat(Items.'Item Desc.');

but it copies the items with a comma between them. Is there any way to change this to a hard return (paragraph mark)?

I'm been trying to solve this with a loop but I'm a newbie and would love any help. Thanks

Ninox Profile

Try this:

–––
LongDescription := replace(concat(Items.'Item Desc.'), ", ","

")
–––

Birger

S

That worked!

Thank you!

Reply