Is there a function or custom ways to convert strings into camel case on DQS - Data Quality services?
Solved
DQS - camel case
- Data Pioneer
- 36 replies
Best answer by AKislyakov
Hi
for such case there is an optional parameter leaveExcsAsTheyAre in capitalizeWithException(string srcStr [, boolean leaveExcsAsTheyAre=false] [, 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')
- Ataccamer
- 149 replies
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. |
- Data Pioneer
- 36 replies
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
1 person likes this
- Ataccamer
- 149 replies
- Answer
Hi
for such case there is an optional parameter leaveExcsAsTheyAre in capitalizeWithException(string srcStr [, boolean leaveExcsAsTheyAre=false] [, 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
Most Liked this week
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.