Trim problem

  • Thread starter Thread starter Ayala
  • Start date Start date
A

Ayala

Hi all,

I have a string field which length I don't know (given by
the user), what I know is that the string will have a
number at the beginning and then letters, but I don't know
how many numbers and letters. I need to pick only the
number and save it in other variable. ex.

I get I want
12345adkcvjgr ---> 12345
3dfg ------------> 3
67gfhhted ---------> 67
89765454a ---------> 89765454

The only pattern is that the number will be at the
beginning...



any thoughts?
 
Ayala,

Try the Val() function. It will return the number part of a string, as
long as that number is found at the beginning of the string.

hth,
 
Thank you very much Cheryl :-)
-----Original Message-----
Ayala,

Try the Val() function. It will return the number part of a string, as
long as that number is found at the beginning of the string.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.
Click to expand...
 
Back
Top