How to merge ASIA and Asia together? and delete the row Asia EYFHQEUFBEHUFBYEFB

[William_Dumfries]

Hello boys and girl, I am doing data cleaning and found myself a bit of trouble. How do I merge this 2 nominal rows Asia and ASIA together and at the same time delete the ASIA? Please help lads dying here.

[ipazin]

Hello @William_Dumfries,

and welcome to KNIME Community!

You can use capitalize() function from String Manipulation node. For every version of word “asia” it will output Asia.

Br,
Ivan

[William_Dumfries]

Yo thanks boss. I did it like that correct me if im wrong.

However after I did my United States has become UniTed sTaTes ahahha. Is there anyway to solve this boss?

[ipazin]

Hello @William_Dumfries,

just use capitalize($region_of_birth$)

Br,
Boss

[William_Dumfries]

EYYYYYY, LETS GOOOOOOOOOOO found it thanks Boss, you should be the CEO of Microsoft brother, thanks so much.

[William_Dumfries]

Sorry last question, How do you the same thing but instead with the rule engine node?

[ipazin]

Hello @William_Dumfries,

in Rule Engine it would be a bit harder as there are no such functions. You would have to write each combination of each word as a separate rule. Regular expression could help but still you would need at least one rule for each word…

Br,
Ivan

[William_Dumfries]

Thanks so much boss really appreciate, sorry to bother you.