Is there a function or custom ways to convert strings into camel case on DQS - Data Quality services?
Solved
DQS - camel case
- Data Pioneer
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
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
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
- Ataccamer
- 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')
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.