KAPITYAN 2 Posted March 8, 2019 Report Share Posted March 8, 2019 I am using a case statement to make a q (if it is there) an upper case QHere is the CASE WHEN Charindex('q',[@field:pNumber],0)=1 THEN UPPER([@field:pNumber]) ENDI also want to remove any spaces and '-' in the string pNumber. Can I do all that in one formula statement? Quote Link to post Share on other sites
0 NailDyanC 10 Posted March 8, 2019 Report Share Posted March 8, 2019 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. Quote Link to post Share on other sites
0 Glitch 19 Posted March 16, 2019 Report Share Posted March 16, 2019 Thank you for this post, this is so helpful. How can I remove spaces and dashes at the same time? Quote Link to post Share on other sites
0 NailDyanC 10 Posted March 16, 2019 Report Share Posted March 16, 2019 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 Quote Link to post Share on other sites
Question
KAPITYAN 2
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?
Link to post
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.