Stripping out characters after a point
Posted on 2011-03-07
Good day experts.
I have a column in my table that sort of contains a member number, although between the two systems I'm working on there are formatting issues.
In Database 1 I have values like XX23/34564 1 or XX33/54566C9
which correspond to Member numbers in Database 2 of 2334564 and 3354566.
What I want to be able to do is strip out everything after the numeric value after the / character. I can then replace the non numeric values and get my member numbers.
How difficult would this be ? Would I need a function to do this
Your assistance as always appreciated