Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Expression mapping and filtering

Highlighted
Seven Stars

Expression mapping and filtering

Hello,

 

I'm wondering if it is possible to do this. I have a file that I will going to load to the table. So from file, I have a data for column CatDog_Count on the destination table I have a column Dog Count.

 

On CatandDogcount Column there is a value like this:

The count of a dog is 45623

 

I only want the numbers to be inserted on the destination table or on Dog Count column, so that I can remove those "The count of a dog/cat is". What should be the right syntax/command for that? Thanks for any help!

Highlighted
Seven Stars

Re: Expression mapping and filtering

UP

Highlighted
Employee

Re: Expression mapping and filtering

Hi,

 

    I believe this is a more generic version of your problem depicted in your another post (link below)

 

https://community.talend.com/t5/Design-and-Development/how-to-load-only-the-values-needed-using-tMap...

 

    Since I have given the answer for your other post, could you please mark this post also as resolved? 

 

Warm Regards,

 

Nikhil Thampi

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog