• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

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.  
0
LJ083198
Asked:
LJ083198
1 Solution
 
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
 
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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
 
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
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now