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
Page 1 / 1
You can use the FuzzyStringComparer or the FuzzyStringCompareFrom2Datasets.
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.
Alternatively, since they all seem to concern differences in uppercase/lowercase usage, you can do the comparison with the @LowerCase() or @UpperCase() function.
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.
If 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(efieldname]))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