Deduplicate AutoCalc

[adatasol]

Ok - i have 10 fields of phone numbers, like home phone, home fax, business phone, business fax, etc.  I want to get a list of area codes from these, separated by spaces with unique values, and if the phone numbers get updated I want it to be properly updated.  

I have used a reduplicate custom function but this removes the duplicates from a return delimited list, so it only works once, not recursively. 

Thanks for your help.

[Ocean West]

Custom List Function is your friend: 

 

http://www.fmfunctions.com/functions_display_record.php?functionId=118

 

http://www.fmfunctions.com/functions_display_record.php?functionId=151