https://community.qlik.com/t5/Talend-Studio/Replacement-for-SQLike-in-tMAP/m-p/2226029#M18079 Hi All, <BR /> I am using TOS and we do not have SQLike Category/function in TOS. But I want to run a job which was built in Commercial version which had SQLike function. So now I am looking for a replacement for SQLike Function. Would you please suggest me what can be used for that? <BR />The full String is as below: <BR />(StringHandling.TRIM(StringHandling.LEFT(SQLike.mid(SAMPLData.DATA,11),4))) <BR />Please suggest or let me know in case of any questions. <BR />Thanks for the help... Fri, 28 Dec 2012 09:44:54 GMT Anonymous 2012-12-28T09:44:54Z https://community.qlik.com/t5/Talend-Studio/Replacement-for-SQLike-in-tMAP/m-p/2226029#M18079 Hi All, <BR /> I am using TOS and we do not have SQLike Category/function in TOS. But I want to run a job which was built in Commercial version which had SQLike function. So now I am looking for a replacement for SQLike Function. Would you please suggest me what can be used for that? <BR />The full String is as below: <BR />(StringHandling.TRIM(StringHandling.LEFT(SQLike.mid(SAMPLData.DATA,11),4))) <BR />Please suggest or let me know in case of any questions. <BR />Thanks for the help... Fri, 28 Dec 2012 09:44:54 GMT https://community.qlik.com/t5/Talend-Studio/Replacement-for-SQLike-in-tMAP/m-p/2226029#M18079 Anonymous 2012-12-28T09:44:54Z https://community.qlik.com/t5/Talend-Studio/Replacement-for-SQLike-in-tMAP/m-p/2226030#M18080 Fell free to build your own routine. The whole magic is in a static Java method. <BR />It would suggest open it in the enterprise version, take a look into the built-in routine there to get an idea how to build your own in your TOS environment. Fri, 28 Dec 2012 13:07:23 GMT https://community.qlik.com/t5/Talend-Studio/Replacement-for-SQLike-in-tMAP/m-p/2226030#M18080 Anonymous 2012-12-28T13:07:23Z