Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

remove delimiter if combinevalues empty

I have a large COMBINEVALUES doing combination of Ifs...but when there results all return false, it returns "" for the ifs, so the combinevalues resutls returns the delimiter only.  How do I not retu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yeah, the reason i didn't is because it's really long.

 

It's basically Switch(condition, 

IF statement,

IF statement,

IF statement,

IF statement with combinevalues(", ", if statement, if statement, if statement, if statement, if statement, if statement)

IF statement,

IF statement,

IF statement,

IF statement,

)

 

If all those if statements inside combinevalues return as false (false condition returning ""), then combinevalues returns ",,,," as the result.  Which is correct, but I don't want those delimiters?  i want it to return "".  And I don't want to have to repaste the if statements and make it twice as long suddenly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

Try the folllowing and add an IF statment

IF(combinevalues(", ", if statement, if statement, if statement, if statement, if statement, if statement) = ",,,,",
BLANK(), combinevalues(", ", if statement, if statement, if statement, if statement, if statement, if statement))

This will put a blank insted of ",,,,".

You can replace the BLANK() with "" if needed, for an empty string/text.

 

Good Luck!
A

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks AClerk, I get that, the thing is I want to specifically not do it that way because doesn't it then need to process twice?  When hitting a bunch of records, that seems like I'm doubling my resource usage.

     

    Isn't there a method of testing the result afterwards, like if(result = ",,,", "", result) ?