Replace truncated name with the more complete name provided

What tool that I can use to replace truncated name with the complete name provided in the other files

Truncated Name in Distributor column (Entertainment Stu...):

Truncated Name

Complete Name:

Complete Name

Workflow

Datasets

Accepted answers

As I see the data's shared, I see the truncated values are ending with ...

Hence use filter tool to filter all the truncated values.

Then use Find and Replace tool to get the solution.

Many thanks

Shanker V

All comments

As I see the data's shared, I see the truncated values are ending with ...

Hence use filter tool to filter all the truncated values.

Then use Find and Replace tool to get the solution.

Many thanks

Shanker V

Thanks but what I need to write in the Filter Tool in order to filter out the truncated value?

Hi @Dinie_Hazim

Please find the sample solution.

Many thanks

Shanker V

okay. got it. I need to change the data type to string first

Thank you very much @ShankerV

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703