I want to search through a text field that has numbers throughout it such as 1046666763. This could be once or 40 times throughout the text. Each time I find one of these, I want to call a function and replace it with a date (I already have the function). How would I search for numbers that are 10 digits and all start like this one??
One way you could do it is go through the string a character at a time and see if its a number or not using the MICROSOFT.VISUALBASIC.ASC function which whill return the ascii value of a character. <BR><BR>Then you would need to determine the next 9 characters were as well. If thats the case then you can just replace the 10 digit number you know have with your date.