Removing Spaces in CASE WHEN

[KAPITYAN]

I am using a case statement to make a q (if it is there) an upper case Q

Here is the 
CASE WHEN Charindex('q',[@field:pNumber],0)=1 THEN UPPER([@field:pNumber]) END

I also want to remove any spaces and '-' in the string pNumber. Can I do all that in one formula statement?

[NailDyanC]

Hi,

Regarding with this issue, Can you try use REPLACE in order to remove the spaces in the result. You can try this formula:

CASE WHEN Charindex('q',[@field:Namee],0)=1 THEN Replace(UPPER([@field:pNumber]), ' ', '') END

Hope that works for you.

[Glitch]

Thank you for this post, this is so helpful. How can I remove spaces and dashes at the same time?

[NailDyanC]

Hi @Vanellope ,

You can try this formula:

CASE 
WHEN Charindex('q',[@field:pNumber],0)=1 THEN Replace(Replace(UPPER([@field:pNumber]), ' ', ''), '-', '') 
ELSE
Replace(Replace([@field:pNumber], ' ', ''), '-', '') 
END