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!
I believe this is a more generic version of your problem depicted in your another post (link below)
Since I have given the answer for your other post, could you please mark this post also as resolved?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema