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.PR ODUCT_FAMI LY_NAMES}, chr(10), "")
So, as a recap:
My select expert is set to:
{BAX_V_CCMS_CHANGE_RECORD. PRODUCT_FA MILY_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
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
So, as a recap:
My select expert is set to:
{BAX_V_CCMS_CHANGE_RECORD.
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can Grow option is vertical only.
mlmcc
mlmcc
ASKER