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!
