like these type of name in a field I want select
Ravindra BarathiRavindra barathiState Banck Of IndiaState Banck of IndiaRavi KiranRavi kiranRayamal PurRayamal purAndra PradeshAndra PradeshVijayavadaVijayaVada
Question
I want selected same like little difference names in a field
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
If the only differences are in the case (and not in the spelling), you can simply convert everything to either upper or lower case before comparing.
+62- Celebrity
Alternatively, since they all seem to concern differences in uppercase/lowercase usage, you can do the comparison with the @LowerCase() or @UpperCase() function.
+33- Influencer
i think in your example the only differences are the cases of some letters?
if this is the only difference you want to compare than you can set the comparison mode to 'case insensitive' in a tester for example:
Alternatively, since they all seem to concern differences in uppercase/lowercase usage, you can do the comparison with the @LowerCase() or @UpperCase() function.
how to use the @LowerCase() or @UpperCase() function.
You can use the FuzzyStringComparer or the FuzzyStringCompareFrom2Datasets.
it is a single field
how to use the @LowerCase() or @UpperCase() function.
You can also use the StringCaseChanger transformer.
it is a single field
Then you should go for @david_r's answer with the StringCaseChanger, using the Full Title Case setting.
+10If the attributes are in the same dataset, I would use the suggestion by @becchr, otherwise I would use the FME string functions as suggested by @redgeographics in a FeatureMerger. In that case you could use:
@LowerCase(@Value([fieldname]))You should set that in both the Requestor and Supplier fields in the 'Join On' part.
You can use the FuzzyStringComparer or the FuzzyStringCompareFrom2Datasets.
I don't want change replace the Characters just for identification