Skip to main content

Anyone ever see any sort of addon that takes a single text field representing any sort of "contact" name as input, and outputs text fields that splits the name(s) up intelligently based on what the input looks like?  Either inside SF or outside?

 

As in....

 

"John Fine" --> "John" "Fine"

"Fine John" --> "John" Fine" (intelligent guess based on a list of common first names)

"John Fine and Jane Doe" --> "John" "Fine" "Jane" "Doe"

"Mary Jane Smith" --> "Mary Jane" "Smith"

"Mary Van den Berg" --> "Mary" "Van den Berg" (knows about common last name patterns in various languages)

"Smith Foundation, John Fine, Executive Director" --> "John" Fine" plus a special org field "Smith Foundation" (OK, this would be pretty darned hard to figure out)

"Mr. John Fine" --> "John" "Fine"

"yuidhjnskfhdk" --> "" (filter out robo garbage)

 

I'm just thinking blue sky about how to get name fields to arrive clean in SF, esp when coming from automated sources that sometimes mash them up terribly.

 

Or at least export, process outside of SF, then reimport.

 

@Salesforce.org System Administrators 

4 Antworten
0/9000