Removing line numbers from a text file

[marine0411]

How do you write a function to remove line numbers from a text file with a random number of lines?

 

[Zathras]

See thread707-615854 for a routine that processes a text file. You might be able to modify it to meet your needs.

 

[VBOnly]

Here is a easy solution if by "numbers" you mean [0..9] not including "."
function Delete0to9(byval s as string) as string
dim i as integer
for i = 0 to 9
s=replace(s, cstr(i),"&quot
next i
Delete0to8 = s
end function

I think Replace function allow you to replace all instance. If not, you have to check if numbers still exist and replace repeatly.

If your VB or VBA does not support Replace, check MS site:

http://support.microsoft.com/default.aspx?scid=kb;en-us;188007

I believe the best solution will be one that use RegExpression in VBScript. But could not remember the exact syntax.