Find and Replace, Beginning of Field help

[wonka1234]

Hi,

I am unable to append records correctly with using beginning of field on my data.

Dataset - norman alex

Dateset 2 - norman alex (NA)

Can someone help me configure the find and replace tool to append the records correctly? 

SHould be like for like.

Also I want the workflow to be able to also account for records just like this

Dataset 1 - norman alex

dataset 2- norman alex.

See workflow attached.

[binuacs]

@wonka1234 Updated the join key value in the first dataset with a formula tool

[wonka1234]

@binuacs  thanks, do you have anything that may get rid of any bracket initials IF it exists? Ie if the persons name is Louis Stevens it may display as Louis Stevens (LS)

[binuacs]

@wonka1234 I updated the formula to remove anything with () will be replaced with blank value 

[wonka1234]

@binuacs  this works but if the word doesnt have brackets it makes it blank! :( 

ie if its just Louis Stevens, it becomes blank!

[binuacs]

@wonka1234 I updated the formula to apply the regex formula only there is ( else no change

[wonka1234]

@binuacs  question, what if there is two brackets in a name? 

ie  Louis (Lamar) Stevens (LS)  and make that into Louis Stevens... IFF the bracketed items exist?

[binuacs]

@wonka1234 @How would you like to see this record in the output ? 

[wonka1234]

@binuacs 

Input  vs output

Louis Stevens (LS)	Louis Stevens
Louis (Lamar) Stevens (LS)	Louis Stevens
Louis Stevens	Louis Stevens

[binuacs · Accepted solution]

@wonka1234 Try the updated workflow and let me know if you see any issues