Link to home
Start Free TrialLog in
Avatar of Nicole McDaniels
Nicole McDaniels

asked on

Join parameter values are adding a carriage return

I have a multi select parameter for Product Name. To display the parameters the user chose, I have the formula:
join ({?Product Name},",")

However, when It displayed, it added a carriage return for some strange reason. I'm assuming the way the text is being stored in the view is causing this. Is there a way to strip out the carriage return (or maybe it's a blank field?) and then join the parameter values? I know this formula strips out the blank fields but I don't know how to incorporate it with my join formula.

replace({BAX_V_CCMS_CHANGE_RECORD.PRODUCT_FAMILY_NAMES}, chr(10), "")

So, as a recap:
My select expert is set to:
{BAX_V_CCMS_CHANGE_RECORD.PRODUCT_FAMILY_NAMES} = {?Product Name}

Product Display formula: join ({?Product Name},",")

User selects from Dynamic Parameter:
BUMINATE
ADVATEADAMTS13 (when displayed, there is no space)

But my parameter display formula is displaying as:
BUMINATE, ADVATE
ADAMTS13

and what I want is:
BUMINATE, ADVATEADAMTS13
User generated image
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Nicole McDaniels
Nicole McDaniels

ASKER

That worked. Thanks! (And I did have the field "can grow" and stretched out so it was a CR
Can Grow option is vertical only.

mlmcc