topic Re: Expression mapping and filtering in Talend Studio

Expression mapping and filtering

Anonymous — Thu, 25 Oct 2018 23:27:21 GMT

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!

Re: Expression mapping and filtering

Anonymous — Fri, 26 Oct 2018 06:14:56 GMT

Re: Expression mapping and filtering

Anonymous — Sat, 27 Oct 2018 20:07:28 GMT

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/m-p/139210#M86135

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

Warm Regards,

Nikhil Thampi