LeoLionHeart
Programmer
I have a string such as 013548 - Jo Bloggs. How do I just return the number part.
For example, I want to loop from 1 to the length of the string. If the value = ' - ' Then exit loop. Store the position of the '-' and calculate left(string, strored position -2).
Any ideas?
For example, I want to loop from 1 to the length of the string. If the value = ' - ' Then exit loop. Store the position of the '-' and calculate left(string, strored position -2).
Any ideas?