@swarnaliD2401 Is it a specific pattern or something ? Did you go through the other function alias that is available ? You could also try two or three function alias combined. For e.g if you have a string which is 15 characters long and you want to take 1 to 5 and 10 to 15 you can use two substring function alias in a concat function alias. Can you please clarify your requirement or give some eg. so it would be easy to suggest the solution.
Posted: 3 months ago
Posted: 28 Oct 2022 5:38 EDT
swarnali Deb Roy (swarnaliD2401)
I think it would be feasible only with a function alias wherein based on which if key matches the text say "ABC" then the corresponding value of the key value pair has to be replaced with null no matter what value it holds.