strip characters

A file is open as Random.  I need to look at a field and strip the alphas out so all I have left are numerics.  I have created a user defined type, and can get to the field this way.  I am at a loss as to how to get the program to read one character at a time and get rid of the letters.  
LJ083198Asked:
Who is Participating?
 
vijayrajCommented:

Dear LJ
          This best  method would be to read the entire file into a string .

In the first parse of string if ascii value of the character is less than 48 or its freater than 57 then at that substitute the character by space.

In the second parse read the string and if character is not space then write it into the same file and save it. That should give you the result


If you have any doubts email to me at vijay_raj_b@hotmail.com
0
 
cymbolicCommented:
see the following
0
 
cymbolicCommented:
A subroutine that will translate out any character and replace it with any other character string:

Public Function SubTran$(Inst$, lookfor$, ByVal Change2$)
 Dim i, j As Integer
 Dim InString$
 InString$ = Inst$
 j = 1
 i = InStr(j, InString$, lookfor$)
 While i > 0
   InString$ = Left$(InString$, i - 1) + Change2$ + Mid$(InString$, i + Len(lookfor$))
   j = i + Len(Change2$)
   i = InStr(j, InString$, lookfor$)
 Wend
 SubTran$ = InString$
End Function
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
sbmcCommented:
fld=field
result=""
for i=1 to len(fld)
  ch=asc(mid(fld,i,1))
  if ch >= 48 and ch <= 57 then result=result & chr$(ch)
next i


Result should ony contain numerics after this routine.
0
 
cymbolicCommented:
A vb version of the translate instruction:

Public Trn$
'somewhere do once up front (form load? read from file?)
'set up translate table
dim i as integer
trn$=space$(256)  'default to spaces when not a number
for i=48 to 57  'Ascii 0 to Ascii 9
 mid$(trn$,i,1)=chr$(i)
next i

'then to translate
x.fld=xlt$(x.fld)

'then a subroutine
public function xlt$(instr$)
dim x$
dim i as integer
x$=space$(len(instr$))
for i =1 to len(x$)
 mid$(x$,i,1)=mid$(trn$,asc(mid$(instr$,i,1)),1)
next i
xlt$=x$
end function
0
 
cymbolicCommented:
or, what sbmc sez, cause he typed it in before I got around to it, but that was next, but only if you want to just concatenate all numerics together.  The key is knowing where in the Ascii range of 0 to 255 the number characters fall.  

On a vb functional basis, there is always the IsNumeric function, but that carries a load of code around to check for numeric in an entire string.
0
 
LJ083198Author Commented:
It is not that this answer is unsatisfactory, I just used the solution provided by sbmc.  It seemed much more straightforward, and it worked. As far as sbmc answer goes, I thought it was an A.
0
 
dabelleiCommented:
There's also some function API that you can use wich are isalpha()  and isnumeric()  if you need more info let me know about it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.