12-29-2017 08:56 PM
I have the following data with company name and TIC code.
Now with TIC code that have character '.' , I would like to extract only characters before the '.'
For example, TIC code CAVR.1 will be sub-stringed to CAVR
The output looks like this:
Can anyone help me with this, please? Any idea would be much appreciated
Need further help from the community? Please ask a new question.