Is it N/A which occurs everywhere? or you are suggesting that there could be anything after the number?
If it is N/A then you can do a mere split by using the delimiter as N. Also if it is due to extra space or unwanted charachters then use the Trim.
If it is N/A then you can do a mere split by using the delimiter as N. Also if it is due to extra space or unwanted charachters then use the Trim.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.