how to group/ do correction for similar character value

[chenzinc]

I am validating a huge 8000 observations dataset. And there is one column named Brand.

what the data shows:

Nike

nikes

nikeshoe

Nike shoe

nike brand

Nike.

what i want:

Nike

how can I do corrections and group them together? 

[ChrisNZ]

How?
You need to define rules and apply them.

You cannot do 2 until you've done 1. 

How do you decide to group these characters strings into the same group? 

[chenzinc]

how can I change all the strings name to just only Nike?

[Ksharp]

if find(have,'nike','i') then flag='Nike' ;

[ChrisNZ]

so  Moniker  is a good match?  pannikel too? 

[Ksharp]

Chris,
I don't realize it is a fuzz match problem. Just gave OP a start point .

[ChrisNZ]

> how can I change all the strings name to just only Nike?

Since you make no rules then this code matches your requirements:

if 1 then STRING='Nike';