How to perform multiple consequential functions using Formula DataType?
I want to replace multiple characters from a TextField (TITLE) using Formula DataType functions.
Let’s Say TITLE = DESK!TO$P AND desired outcome = DESKTOP
Replace([@field:TITLE], '!', '') AND Replace([@field:TITLE], '$', '') INVALID
THE "CASE, WHEN THEN" STATEMENT PERFORM THE FIRST TRUE STATEMENT ONLY
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.
Question
Esraaa
How to perform multiple consequential functions using Formula DataType?
I want to replace multiple characters from a TextField (TITLE) using Formula DataType functions.
Let’s Say TITLE = DESK!TO$P AND desired outcome = DESKTOP
Replace([@field:TITLE], '!', '') AND Replace([@field:TITLE], '$', '') INVALID
THE "CASE, WHEN THEN" STATEMENT PERFORM THE FIRST TRUE STATEMENT ONLY
Link to comment
Share on other sites
2 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.