One Star

I try to convert guid to an integer for a new database

Hello,
For my migration of two CRM i need to convert many GUID into integer id ...
How can I do that with a tmap ?
Thank you i'm looking for a while !
1 REPLY
Seventeen Stars

Re: I try to convert guid to an integer for a new database

It depends what you want. You could use the hashCode() method to build an integer from the String guid.
use as expression
row1.GUID.hashCode()
But please keep in mind an hashCode is not fully unique. If your GUID string has always nearly the same length it is very likely unique but if the guid has wide spread length, this will not work for a huge number of values.