Make CONCAT take an arbitrary number of arguments
Currently, CONCAT only takes 2 arguments, so you need to nest multiple CONCAT (or just use the & operator) if you want to concatenate multiple strings. This can be avoided if CONCAT could take any number of strings as arguments.
In general, users expect associative functions to take an arbitrary number of arguments.
Kenneth Barber
shared this idea
Thank you for your input. We are continuing to support PI Connector for UFL with stability and security releases. However, for feature enhancements, we are starting to develop the PI Adapter for Structured Data Files and encourage you to go to the PI Adapters forum to share your use cases.
2 comments
-
Kenneth Barber
commented
Good point, Gabriel. However, I think that my suggestion still holds. We might not need the CONCAT function at all to concatenate strings, but since the CONCAT function does exist, it might as well be given an upgrade.
-
Gabriel Verreault
commented
You can use the "+" operator. MyVar="Hello"+Var2+"World"+Var3