Changing Cloud Platform to Cloud_Platform

[Sjkitts]

I'm trying to change Cloud Platform to Cloud_Platform and it has been successful when the cell just says Cloud Platform but when it is after a comma (see screenshot) it isn't working. I've tried two different statements. Why might it not be working??

[DataNath · Accepted solution]

@Sjkitts currently, you're only checking whether or not the string = Cloud Platform OR ,Cloud Platform. However, if the string isn't solely 'Cloud Platform', i.e. if it comes after the comma, you should be checking whether or not it contains ',Cloud Platform'. If you try the following, does this remedy the issue?

IF [Custom Value 4] = 'Cloud Platform' then 'Cloud_Platform' else Replace([Custom Value 4], ',Cloud Platform', ',Cloud_Platform') endif

[Sjkitts]

Thank you very much!!