Replace truncated name with the more complete name provided

[Dinie_Hazim]

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

[ShankerV · Accepted solution]

@Dinie_Hazim 

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

[Dinie_Hazim]

@ShankerV 

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

[ShankerV]

Hi @Dinie_Hazim 

Contains([Column_name],"...")

[Dinie_Hazim]

@ShankerV 

I already did that but it didn't filter out the values that end with ...

[ShankerV]

Hi @Dinie_Hazim 

Please find the sample solution.

Many thanks

Shanker V

[ShankerV]

Hi @Dinie_Hazim 

Could you please share the workflow or the input data's of both files.

Because its working at my end as per the sample shared initially.

Will check and resolve the issue.

Many thanks

Shanker V

[Dinie_Hazim]

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

Thank you very much @ShankerV 

[ShankerV]

@Dinie_Hazim 

Welcome, happy to support. 

Merry Christmas!!!!