Text to Numbers
Trying to automatically assign a unique number for varying length (40+/-
char) text fields. For example, "Main Street" might return 54580546, whereas 'Broadway' would return 885213369. Numbers would be the surrogate key for the text. Application is to document data lineage of data elements in a database, and need to assign a key to elements so that a parent can be assigned. thx |
All times are GMT +1. The time now is 04:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com