Hi
I'm getting values in my data like 'New york' because of that it doesn't match with my lookup(LU) as it keeps 'New York' (First letter of each word should be capital but in my data some time its keep small letter)
I was thinking to use something like title(New york) which should change to 'New York'.
IS there any function I can use as I can only see "Upper" under string function under transformer control.
I've searched the following on this forum, some one advised use CAPITAL but not found.
second advised to use function made in C++ I can not see that function too and don't know how to write using C++ and how to call in my transformer stage.
Do you think I can use two function like UPPER and Space to get this work,
hope make sense
Many thnaks
Farhan
Title Case
Moderators: chulett, rschirm, roy
The advise to use CAPITAL also specifically said to use it in a BASIC transformer as it is a Server transform. If you're not fluent in C++ don't even start down that path as it is dangerous and full of pitfalls. If you are trying to match two strings regardless of case, best advice has always been to "upper" (or lower would work too) each side before doing the comparison.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
