Is there a function or custom ways to convert strings into camel case on DQS - Data Quality services?
Page 1 / 1
There is capitilize function with following description
Transforms all words in the string srcStr in the following manner: The first character of each word to upper case and all following characters to lower case. A word consists of alphabetic characters (letters). All other characters are considered separators. |
Thank you.
The CapitalizewithException() does the same but convers exceptions into lower case
example:
capitalizeWithException(upper(out_name),'BLVD')
out_name:’123 capital BLVD’
returns: ’123 Capital blvd’
Is there a function I can use along with this, which would keep ‘BLVD’ as is
Hi
for such case there is an optional parameter leaveExcsAsTheyAre in capitalizeWithException(string srcStr g, boolean leaveExcsAsTheyAre=false] l, string exc]...)
If the parameter leaveExcsAsTheyAre is set to true, the transformation leaves words from exc as they are in the string srcStr, i.e. without any change. |
So, you want something like capitalizeWithException(upper(pur_city), true, 'BLVD')
Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
