0

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

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

2 replies

null
    • Support
    • 6 yrs ago
    • Reported - view

    Try this:

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

    ")
    –––

    Birger

    • sonicjoy
    • 6 yrs ago
    • Reported - view

    That worked!

    Thank you!

Content aside

  • 6 yrs agoLast active
  • 2Replies
  • 1655Views