Replacement for SQLike in tMAP

One Star

Replacement for SQLike in tMAP

Hi All,
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?
The full String is as below:
(StringHandling.TRIM(StringHandling.LEFT(SQLike.mid(SAMPLData.DATA,11),4)))
Please suggest or let me know in case of any questions.
Thanks for the help...
Seventeen Stars

Re: Replacement for SQLike in tMAP

Fell free to build your own routine. The whole magic is in a static Java method.
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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download