Find and Replace, Beginning of Field help

@binu_acs 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)

binu_acs

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

find and replace beginning of field.yxmd

wonka1234

@binu_acs this works but if the word doesnt have brackets it makes it blank!

ie if its just Louis Stevens, it becomes blank!

binu_acs

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

find and replace beginning of field.yxmd

wonka1234

@binu_acs 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?

binu_acs

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

wonka1234

@binu_acs

Input vs output

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

binu_acs

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

find and replace beginning of field.yxmd

wonka1234

@binu_acs seems like there is an extra space in the 2nd row of your output!

binu_acs

@wonka1234 Can you screenshot where you are seeing the space? I do not see them in my workflow

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703