Data Cleansing Hyphen

[mustufa2019]

I am trying to perform data cleansing and remove hyphen between names and remove the spaces. See below example:

Input:

First Name	Last Name
Jack	Smith-Owen
David	Flintoff
Andrew	Lehman-Smith
Ahmed	Abdul-Karim

Output:

First Name	Last Name
Jack	SmithOwen
David	Flintoff
Andrew	LehmanSmith
Ahmed	AbdulKarim

[BrandonB · Accepted solution]

You can do this using a formula tool. Set the field to Last Name

Replace([Last Name], "-", "")

[MattR79]

I have tried to do this but I am getting a "The field "" is not contained in the record" error as seen in the attached comment.  Is there something that I am missing?

[atcodedog05]

Hi @MattR79 

Can you provide snapshot of the error.

[MattR79]

Forgot to attach the screenshot it is attached here.

[MattR79]

Just attached it.

[atcodedog05]

Hi @MattR79 

You need to select the output column. If you are trying to replace in same column give same column name as output column(in your scenario [Source Ref Bo (Out)])

Hope this helps : )

[MattR79]

Yep, that worked.  I knew I was missing something simple.  Thanks a lot.

[atcodedog05]

Happy to help : ) @MattR79