Lightwave
Ad astra
- Local time
- Today, 14:26
- Joined
- Sep 27, 2004
- Messages
- 1,537
OK this isn't quite as simple as the title states - I've tried CINT and Val functions don't quite get it right.
I'm currently doing a transform of data between systems and I have a table of of Tables... which relate to mapping.
I would like a number to uniquely identify each table which at present are uniquely identified by a text string.
Is there a function that will consistently convert a text string to a number eg
ABBA = 1221
CBD = 324
etc... so that if tables are in different tables they can be mapped to an equivalent index. The actual index doesn't matter if it is more or less digits so long as it is consistent.
I'm trying google but its not coming out for me.
I'm currently doing a transform of data between systems and I have a table of of Tables... which relate to mapping.
I would like a number to uniquely identify each table which at present are uniquely identified by a text string.
Is there a function that will consistently convert a text string to a number eg
ABBA = 1221
CBD = 324
etc... so that if tables are in different tables they can be mapped to an equivalent index. The actual index doesn't matter if it is more or less digits so long as it is consistent.
I'm trying google but its not coming out for me.