Skip to main content
Question

I want selected same like little difference names in a field


tomjerry.vl
Forum|alt.badge.img

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

10 replies

Forum|alt.badge.img
  • December 10, 2019

You can use the FuzzyStringComparer or the FuzzyStringCompareFrom2Datasets.


david_r
Celebrity
  • December 10, 2019

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.


redgeographics
Celebrity
Forum|alt.badge.img+50

Alternatively, since they all seem to concern differences in uppercase/lowercase usage, you can do the comparison with the @LowerCase() or @UpperCase() function.


becchr
Influencer
Forum|alt.badge.img+26
  • Influencer
  • December 10, 2019

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:


tomjerry.vl
Forum|alt.badge.img
  • Author
  • December 10, 2019
redgeographics wrote:

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.


tomjerry.vl
Forum|alt.badge.img
  • Author
  • December 10, 2019
danullen wrote:

You can use the FuzzyStringComparer or the FuzzyStringCompareFrom2Datasets.

it is a single field


david_r
Celebrity
  • December 10, 2019
tomjerry.vl wrote:

how to use the @LowerCase() or @UpperCase() function.

You can also use the StringCaseChanger transformer.


Forum|alt.badge.img
  • December 10, 2019
tomjerry.vl wrote:

it is a single field

Then you should go for @david_r's answer with the StringCaseChanger, using the Full Title Case setting.


lars_de_vries
Forum|alt.badge.img+10

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([fieldname]))

You should set that in both the Requestor and Supplier fields in the 'Join On' part.


tomjerry.vl
Forum|alt.badge.img
  • Author
  • December 10, 2019
danullen wrote:

You can use the FuzzyStringComparer or the FuzzyStringCompareFrom2Datasets.

I don't want change replace the Characters just for identification


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings