hi im looking for a function do to the following
(12345 example1), i want to remove example1 and keep the numeric 12345, however 12345 can change in length ie 123/12 i have tried (left x) but its not good enuff due to the chaning sizes of the left side of my string.
Cheers for the help kevin!
(12345 example1), i want to remove example1 and keep the numeric 12345, however 12345 can change in length ie 123/12 i have tried (left x) but its not good enuff due to the chaning sizes of the left side of my string.
Cheers for the help kevin!